| Subject: | Re: query takes 60 seconds to run on DEV and 1 second on PROD! |
|---|---|
| From: | "Kronin555" <webforumsuser@xxxxxxxxxxxxxx> |
| Date: | Wed, 25 Jun 2008 20:36:43 +0000 (UTC) |
| Newsgroups: | macromedia.coldfusion.database_access |
How big is the result set? What's the slowest link (network connection) between the production server and the database server? What's the slowest link between the database server and your development box? Possibly stupid question, I'm assuming both dev and production are talking to the same Oracle database? Are the datasources configured the same? (native vs. jdbc vs. odbc/jdbc) |
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | query takes 60 seconds to run on DEV and 1 second on PROD!, BosDog |
|---|---|
| Next by Date: | Re: query takes 60 seconds to run on DEV and 1 second on PROD!, paross1 |
| Previous by Thread: | query takes 60 seconds to run on DEV and 1 second on PROD!, BosDog |
| Next by Thread: | Re: query takes 60 seconds to run on DEV and 1 second on PROD!, paross1 |
| Indexes: | [Date] [Thread] [Top] [All Lists] |