Re: INSERTs getting slower with growing tabel, using no indexes?

2003-02-16 Thread Jerry
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 tab

Re: INSERTs getting slower with growing tabel, using no indexes?

2003-02-16 Thread Peter Grigor
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: &quo

Re: INSERTs getting slower with growing tabel, using no indexes?

2003-02-16 Thread Jerry
think they'd be too noticeable. > > Peter > <^_^> > - > Peter Grigor > Hoobly Free Classifieds > http://www.hoobly.com > > > - Original Message ----- > From: "Magnus Själander" <[EMAIL PROTECTE

RE: INSERTs getting slower with growing tabel, using no indexes?

2003-02-16 Thread Magnus Själander
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 consis

Re: INSERTs getting slower with growing tabel, using no indexes?

2003-02-15 Thread Peter Grigor
//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 cou

INSERTs getting slower with growing tabel, using no indexes?

2003-02-15 Thread Magnus Själander
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