CodeIgniter Forums
Rest Webservice: Problem querying data from Oracle - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forum-20.html)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forum-23.html)
+--- Thread: Rest Webservice: Problem querying data from Oracle (/thread-45674.html)



Rest Webservice: Problem querying data from Oracle - El Forum - 09-30-2011

[eluser]CARP[/eluser]
Hi
I've finished building a webservice following the article and posted code by @philsturgeon at
http://bitly.com/dkzZIn

Everything works fine, I get the output with the data correctly, but the hell shows on when the user inputs a code that doesn't exists in the table from ORACLE db server.

The oracle table seems to have thousands of records. If the code exists in a record, it shows instantly, but if if doesn't exists, it looks like if it searches record by record until nothing found, and I get the error array after 20 or 30 seconds avg...

Any idea or workaround? I don't know the indexes or optimization db has, but I guess it is fine because existent results are returned in 0.xxx ms, very fast

Thanks for any tip you can give me