CodeIgniter Forums

Full Version: CI & Oracle 10g - Large Datasets, Long Response Times
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

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...