Re: Large table doesn't display

Hi Dave Lasar's solution will probs work, but its worth trying to find out why this is happening (needless to say, it shouldn't...) It looks like the server is running out of memory. Does the hard drive start thrashing when running the 10,000 result query? If so, try reducing the amount of memory used by other processes and optimising your query to only process/use the fields/records required. It may help to split the table into two - one for the lookups like that and one to hold all the important data (this will help more if you have text or binary fields in the table). Regards -- Shane On Monday 05 November 2001 6:51 pm, Dave Pollak wrote: > Howdy, > > I've got a table with over 11,000 records that I want to display and print. > I'm running an intranet with mySQL and PHP4 on NT4.0 sp6a. Queries that > return even up to 5000 records are pretty snappy. 7500 or more records are > returned with only a slight delay. 10,000 or more just stop. I've got to > print the whole list. My users don't want to print a page at a time. > > Dave Pollak