I can return result sets of 4K records from a database with 2M records
in tenths of a second. Smaller sets of 100 to 800 records take .02 to
0.1 second. This is on linux, pentium III at 500 MHz, pg 7.2.1.
Finding the right indexes made a *big* difference. Index using
the same criteria you use for select.
--
P. J. "Josh" Rovero Sonalysts, Inc.
Email: rovero@sonalysts.com www.sonalysts.com 215 Parkway North
Work: (860)326-3671 or 442-4355 Waterford CT 06385
***********************************************************************