Re: Slow Query Time for Many Records from Large Table
The slowdown comes from having the total query be around 0.77 sec and having it on a website where many times it is being accessed more than once per second. Thus, the server can bottleneck pretty quick.
It would be nice if I could rebuild the query using BID as the limiting method, though, this parameter is an output, rather than an input.
From the way it sounds, is that it looks like this is about the best I can get with the current schema and record counts. I guess I'll have to look into using another approach. Thanks for your help!
Subject
Views
Written By
Posted
2536
November 08, 2005 05:04AM
1372
November 08, 2005 08:08AM
1336
November 08, 2005 02:21PM
1372
November 08, 2005 02:40PM
1377
November 08, 2005 03:34PM
1470
November 08, 2005 04:10PM
1426
November 08, 2005 05:09PM
1550
November 08, 2005 09:51PM
Re: Slow Query Time for Many Records from Large Table
1317
November 11, 2005 05:54AM
1347
November 08, 2005 08:05PM
1325
November 11, 2005 06:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.