Show status of table question

Ruslan Zasukhin sunshine at public.kherson.ua
Mon Sep 24 13:11:14 CDT 2007


On 24/9/07 9:00 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> Hi List,
> 
> Is it expected behaviour that a table with 5 records in it has in the
> show status for table tblx and ADD Record  = 0.

> I am aware that I did not use add record but inserted records through
> SQL. Shouldn't an insert record augment the ADD record counter
> If this is expected that what use has ADD Record (as a counter)?

SHOW STATUS show runtime counters !
    they are NOT saved into db.

So each new start they go from ZERO.


Or you mean that you have
    START
    INSERT 5 records
    SHOW STATUS => ZERO

?

Then bug 


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]




More information about the Valentina mailing list