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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
