That's what I'm hoping
jerry ----- Original Message ----- From: "Peter Grigor" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 16, 2003 1:39 PM Subject: Re: INSERTs getting slower with growing tabel, using no indexes? > 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
