Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Query results over 200 000 Records ?!?!!??!

Query results over 200 000 Records ?!?!!??!

From: Filiz Duman <none_at_aol.com>
Date: Mon, 25 Nov 2002 12:54:12 -0000
Message-ID: <art6tp$t0r$2@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.



Any ideas ?
Received on Mon Nov 25 2002 - 06:54:12 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US