On Fri, Feb 01, 2002 at 12:15:41AM +0000, Tim Bunce wrote: > On Thu, Jan 31, 2002 at 03:49:29PM -0800, Michael Peppler wrote: > > They probably do a > > select count(*) from ... where ... > > to get that information. > > And then cache it.
.... > > > > > > is there really no resource-friendly, fast&simple way to find out how > > > many rows a query could return, without weeding thru all the rows - i > > > somehow doubt that websites that claim "we have 1.234.678 [whatever] > > > registered in our database" run thru their whole database every time. my > > > is that they store the number of entries every time they do an "INSERT", > > > but still... Make sure that your setup does in fact support that method. Speaking from very fresh, raw and painful experience, it seems that linux -> ODBC -> IBM iSeries driver -> AS/400 does not. -- Christopher F. Miller, Publisher [EMAIL PROTECTED] MaineStreet Communications, Inc 208 Portland Road, Gray, ME 04039 1.207.657.5078 http://www.maine.com/ Content/site management, online commerce, internet integration, Debian linux
