What type of table is it ? Would that effect it ?
Jerry ----- Original Message ----- From: "Magnus Själander" <[EMAIL PROTECTED]> To: "'Peter Grigor'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 9:17 AM Subject: RE: INSERTs getting slower with growing tabel, using no indexes? > 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 > --------------------------------------------------------------------- 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