I'm hoping that it's a MyIsam table. Peter <^_^> --------------------------------------------- Peter Grigor Hoobly Free Classifieds http://www.hoobly.com
----- Original Message ----- From: "Jerry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 5:52 AM Subject: Re: INSERTs getting slower with growing tabel, using no indexes? > 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 > > --------------------------------------------------------------------- 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