Re: INSERT performance when indexes are used

2002-06-03 Thread Jason
Mikko Noromaa" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 03, 2002 9:11 AM Subject: INSERT performance when indexes are used > Hi, > > I have a table with about 5 million records, and an index on that > table's VARCHAR(255) field, as well as a c

INSERT performance when indexes are used

2002-06-03 Thread Mikko Noromaa
Hi, I have a table with about 5 million records, and an index on that table's VARCHAR(255) field, as well as a couple of integer indexes. The VARCHAR-index is essential to my application as I frequently need to search through the whole table by using the VARCHAR field. When I do INSERTs into thi

INSERT performance when indexes are used

2002-06-03 Thread Mikko Noromaa
Hi, I have a table with about 5 million records, and an index on that table's VARCHAR(255) field, as well as a couple of integer indexes. The VARCHAR-index is essential to my application as I frequently need to search through the whole table by using the VARCHAR field. When I do INSERTs into thi