[prev in list] [next in list] [prev in thread] [next in thread] 

List:       phplib
Subject:    Re: [PHPLIB] All SQL Databases: Counting Rows to Infinity
From:       Paul DuBois <paul () snake ! net>
Date:       1999-05-21 15:53:46
[Download RAW message or body]

At 5:59 AM -0500 5/20/99, Alexander Aulbach wrote:
>}I don't approve of M. Aubach's changes, because in the case where Oracle
>}must do any full table scans or scan-merge operations, the call to
>}num_rows() is just as expensive as executing the query.
>
>I don't know how oracle is making this, but mySQL for example has a cache.
>If you make nearly the same query on the same table it is notable faster.
>I couldn't think any reason why oracle hasn't a cache like this.

Is this because MySQL is caching the results, or are you just seeing
the effect of your operating system's native caching?

--
Paul DuBois, paul@snake.net
Northern League Chronicles: http://www.snake.net/nl/
-
PHP3 Base Library Mailing List. Send messages to <phplib@shonline.de>.
To unsubscribe, send "unsubscribe" to <phplib-request@shonline.de> in
the body, not the subject, of your message.

[prev in list] [next in list] [prev in thread] [next in thread]