Welcome Guest, Not a member yet? Register   Sign In
Rest Webservice: Problem querying data from Oracle

I've finished building a webservice following the article and posted code by @philsturgeon at

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

Theme © iAndrew 2016 - Forum software by © MyBB