INSERTs getting slower with growing tabel, using no indexes?

[Magnus Själander <suppressed>]

Hello

I have a simple table consisting of a couple of columns with int-values
and one datetime column. The table doesn?t have any indexes and consists
of over 10 million records and are growing with more then 200 000
records per day. 
Even though I am NOT using an index the time for inserting new rows
takes longer and longer the larger the table become. I find this strange
since the data isn?t organized the time for inserting a row should be
constant regardless of the size of the table. Is it I that is wrong or
is there a way to get the time for insert queries to be of constant time
regardless of the size of the table?

/Magnus





---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <suppressed>
To unsubscribe, e-mail <suppressed>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php