Re: efficient next/prev page generation

SELECT COUNT(*) FROM <table> (only on initial page). Then pass that count from page to page. Then only one query will be necessary for subsequent page requests. The count will not always be accurate if records are added during the users visit. But it's a quicker solution. David Chamberlin <dwc@nautiboy.com> wrote: > Just reviewed my post (should do that *before* hitting submit ... sigh > ). One minor note, which should be obvious, but just for completeness: > David Chamberlin wrote: >> 1.SELECT * FROM <table> >> 2. get the number of rows from result >> 3. figure out paging scheme >> 4. SELECT <desired data> FROM <table> LIMIT >> <startPoint>,<numEntries> > I forgot to include the query criteria. i.e., > 1. SELECT * FROM <table> WHERE/LIKE <criteria> > 2. get the number of rows from result > 3. figure out paging scheme > 4. SELECT <desired data> FROM <table> WHERE/LIKE <criteria> LIMIT > <startPoint>,<numEntries> > -Dave