+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Rest Webservice: Problem querying data from Oracle (/showthread.php?tid=45674)
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