ColdFusion slow in Oracle environment

[Slippenos]

My company recently made the switch from MySQL 5.0 to Oracle 10G some months ago. Put simply, its slow.

Some research followed and discovered that Oracle runs very fast with bind variables; so we used cfqueryparams in every single spot in our application. This helped to some extent- but we need it to run faster (as fast as MySQL was at the very least).

It could be a driver issue, currently we are using Oracle's Native ColdFusion driver (not ColdFusion's Oracle Driver). It is the 'thin' driver to be exact.

Its not a network latency issue as our MySQL box and Oracle box are side by side.

Does anyone out there have any thoughts or any input on this topic? A good driver? Experience with these sorts of nuances?

Thanks in advance,
Mike

[blue]Go to work to learn. Don't go to work to earn.[/blue]

 

[ecobb]

I always used Oracle's JDBC drivers with CF, and never experienced any slowness. Here's a link to a previous thread where I list the steps I took in setting it up.

thread232-1214575

Other than that, then only thing I can think of is to make sure you've got the latest drivers, try using CF's native drivers (I've never tried this), or if all else fails lose the cfqueries and go with Stored Procedures.


Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[TamedTech]

Yep, I've not worked with Oracle myself, but after looking at the TPC data it should be a very string database for you to work with performance wise.

However these kinds of things are always to difficult to solve as there are so many contributing factors, firstly the system requirements to run properly are much higher on the Oracle systems, does your hardware reflect this?

Then you've got to take into account the whole database design and maintanance aspect of it, from my understanding managing and creating databases on Oracle is far more complicated than on MySQL due to the sheer level of power it can offer.

Drivers may well be causing these issues, and from my experiances of using MS SQL Server then the JDBC seem to be the best around, so I'd definatly say giving those a shot as reccomended by ECAR.

Rob

 

[ecobb]

TamedTech makes a good point. Oracle is a completely different beast than MySQL or even SQL Server. If the layout and design of the database was not calculated correctly, then that could very well be your problem. With Oracle, it's not as simple as just creating a table and putting data in it, there is A LOT more involved, and it can be quite complicated.

Have you tried running the same queries in Oracle directly (via SQL*Plus)? Are they slow there? If so, your database design is most likely the problem.


Hope This Helps!

ECAR
ECAR Technologies

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher