"Filiz Duman" <none_at_aol.com> wrote in message
news:art6tp$t0r$2_at_pheidippides.axion.bt.co.uk...
> Hi All,
>
> I was just wondering what can I change in my code, database set-up, table
> set-up
> if I want to run a query which returns usually over 200 000 records.
>
> I am actually using the Apache web server with Oracle 8.1.7 database and a
> web front end (created with database packages PLSQL), but since the query
> does take a very long time to execute (20 min) the user is unable to see
the
> results on the web page.
You don't really give us much to go on, but I'd question the wisdom of any
web page that returns 200,000 results. 20 would be a more appropriate
number. As to speeding up your query can you post the sql and explain plan
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Mon Nov 25 2002 - 07:20:44 CST
