• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Rest Webservice: Problem querying data from Oracle

#1
[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


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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