Re: chronological order of data insert

[cyrille]

Ingo Str�wing wrote:
> As long as you don't delete rows, the .MYD file is
> written in chronological order as well.

that's logical, but a bad confirmation to me.

> When you delete rows, their places in the .MYD
> file might be reused for later inserts (or
> updates, if these enlarge the record).

that a way I'll try. Perhaps inserting N times the same message then deleting N-1 entry of this message. Next messages insert will use this free space.By the way, record will be scrambled.

> MySQL also knows a couple of log files, which log

disabled.

> things like AUTO_INCREMENT or TIMESTAMP

that kind of fields is not used in the problematic table (messages table).

> There might be other things which could affect the
> "traceability" of commands. I just mentioned, what
> jumped into my mind.

Argh, please, could you remember them please ;o)

thanks a lot
cyrille