Christopher Browne wrote:
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] wrote:
MySQL can tell you from it's index because it doesn't care if it gives you the
right number or not.
Under what circumstances would MySQL give the wrong number?
It would give the wrong number under _e
Ang Chin Han <[EMAIL PROTECTED]> writes:
> Heck, even using myisam, mysql's count(*)'s still accurate, since all INSERTs,
> etc are autocommitted.
That's sort of true, but not the whole story. Even autocommitted transactions
can be pending for a significant amount of time. The reason it's accura
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] wrote:
>> MySQL can tell you from it's index because it doesn't care if it gives you the
>> right number or not.
>
> Under what circumstances would MySQL give the wrong number?
It would give the wrong number under _every_ circumstance
> MySQL can tell you from it's index because it doesn't care if it gives you the
> right number or not.
Under what circumstances would MySQL give the wrong number?
--
Mike Nolan
---(end of broadcast)---
TIP 6: Have you searched our list archives?
