Joep Roebroek wrote: > I had this question, which I didn't really know where to ask, so I > thought to begin at this mailing list. > > Very basicly said, I count the rows of a table which had approx 50000 > or more rows. > > The problem is, there is a notable difference in loading time with > other pages. Is there a technique to estimate the number of rows > instead of exactly couting them? So that it saves loading time. How about: SELECT COUNT(*) FROM table WHERE <criteria> ? /Per Jessen, Zürich -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
