The platform I'm using is Windows 2000 with NTFS and the file is around 250MB.
/Magnus -----Original Message----- From: Peter Grigor [mailto:[EMAIL PROTECTED]] Sent: den 16 februari 2003 00:13 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: INSERTs getting slower with growing tabel, using no indexes? What type of platform/file system are you using? Very large files on filesystems can suffer from inode indirection problems...but I wouldn't think they'd be too noticeable. Peter <^_^> --------------------------------------------- Peter Grigor Hoobly Free Classifieds http://www.hoobly.com ----- Original Message ----- From: "Magnus Själander" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 15, 2003 2:08 PM Subject: INSERTs getting slower with growing tabel, using no indexes? 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