CI & Oracle 10g - Large Datasets, Long Response Times

Hi Folks - I'm running an oracle query that was optimized to run in about 3 to 4 seconds, but when I run it via a codeigniter page it runs in double and sometimes triple that time. I'm wondering if there is anything that can be done to speed things up. They are pretty complex queries but like I said, they have been optimized about as far as they can be. Complex MySQL queries run just fine (using the MySQL driver), but oracle ones run slowly (using the OCI8 driver)... any assistance is greatly appreciated...


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  

  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.