Re: Differences between numbers of rows in tables

2006-02-02 Thread Dan Trainor
Joerg Bruehe wrote: Hi Dan, all! Dan Trainor wrote: Thanks for the prompt reply, Augusto - I completely understand what you're saying. To have anything such as a real-time measurement to the exact number of tables would be an incredible preformance degration, not to mention overhead and th

Re: Differences between numbers of rows in tables

2006-02-02 Thread Joerg Bruehe
Hi Dan, all! Dan Trainor wrote: Thanks for the prompt reply, Augusto - I completely understand what you're saying. To have anything such as a real-time measurement to the exact number of tables would be an incredible preformance degration, not to mention overhead and the like. Right. This

Re: Differences between numbers of rows in tables

2006-02-01 Thread Dan Trainor
Thanks for the prompt reply, Augusto - I completely understand what you're saying. To have anything such as a real-time measurement to the exact number of tables would be an incredible preformance degration, not to mention overhead and the like. I think I'm willing to accept the fact that wh

Re: Differences between numbers of rows in tables

2006-02-01 Thread Dan Trainor
James Harvard wrote: I suppose this is an inherent limitation of transactional tables - you might see x rows, but at the same time a use who has just inserted some rows will see x+y rows. However I don't see that the numbers are going to be hugely inaccurate. After all, if the table was MyISA

Re: Differences between numbers of rows in tables

2006-02-01 Thread James Harvard
I suppose this is an inherent limitation of transactional tables - you might see x rows, but at the same time a use who has just inserted some rows will see x+y rows. However I don't see that the numbers are going to be hugely inaccurate. After all, if the table was MyISAM and you get an exact

Re: Differences between numbers of rows in tables

2006-02-01 Thread Dan Trainor
Dan Trainor wrote: Hello, all - Still kidna new to MySQL, so please forgive me if this is somewhat dumb question... When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows column for my table, I see 17333. However, when issuing a 'COUNT (*) FROM table', I see 17203 - a diff

Re: Differences between numbers of rows in tables

2006-02-01 Thread Dan Trainor
Hi - Anyone else get the following message with *ever*single*post* to the list? Anyone have a procmail filter established already? ;) Thanks -dant [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] If you really intend for this to get to me, remove the 'no' in the eMail address above & I'll send

Re: Differences between numbers of rows in tables

2006-02-01 Thread Dan Trainor
Dan Trainor wrote: Hello, all - Still kidna new to MySQL, so please forgive me if this is somewhat dumb question... When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows column for my table, I see 17333. However, when issuing a 'COUNT (*) FROM table', I see 17203 - a diff

Differences between numbers of rows in tables

2006-02-01 Thread Dan Trainor
Hello, all - Still kidna new to MySQL, so please forgive me if this is somewhat dumb question... When issuing 'SHOW TABLE STATUS', I can see clearly that under the Rows column for my table, I see 17333. However, when issuing a 'COUNT (*) FROM table', I see 17203 - a difference of 130. We'