Home » RDBMS Server » Performance Tuning » select large amount of data
select large amount of data [message #122840] Wed, 08 June 2005 14:45 Go to next message
r2d2dev
Messages: 75
Registered: May 2005
Location: bxl
Member
hello;

i was wondering the following:
imagine i have a database with > 10.000.000 records.

in a gui i have a select statement to get around 1.000.000 records. doing a simple select * script that retrieves everything in once would increatse network too much.

how is this problem mostly tackled ? at DB Level or at the level of the GUI ?
Re: select large amount of data [message #122850 is a reply to message #122840] Wed, 08 June 2005 15:47 Go to previous message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
Why are you sending a million records to a GUI in the first place? Would you page through a million records? I wouldn't, not anywhere even remotely close.

Do you know about paginating through a result set, and the FIRST_ROWS hint?
Previous Topic: forced view
Next Topic: What is happening with this sql?
Goto Forum:
  


Current Time: Tue Mar 19 01:43:05 CDT 2024