Ron Stephan wrote: > The way I understand it, it will select all 100,000 and then try and > display them all. Between the server and the browser something is bound > to break or get stupefying slow. Am I wrong? Most of the time people > are going to have filter criteria in the display - maybe it doesn't > matter. But how do I mimic the "show all" logic but only actually show > the first 200 records (and at the end allow a browse to continue through > the next 200 records? > > > > Is this a stupid question?
not at all try the LIMIT clause of MySQL :)
