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

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

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

Table performance, indexing?

2003-02-10 Thread Magnus Själander
Hello I have a performance problem when working against a large table that I hope that I can get some help with. The table stores data that is collected from a monitoring unit for a heating system for a larger house complex. The table is constructed as shown below. Transceiver INT NOT NULL,

Table performance, indexing?

2003-02-10 Thread Magnus Själander
Hello I have a performance problem when working against a large table that I hope that I can get some help with. The table stores data that is collected from a monitoring unit for a heating system for a larger house complex. The table is constructed as shown below. Transceiver INT NOT NULL,