;
To: "Octavian Rasnita" <[EMAIL PROTECTED]>
Cc:
Sent: Tuesday, July 31, 2007 5:27 AM
Subject: Re: inserting data - speed
The most obvious is to make sure you are doing bulk inserts, which you
may already be doing.
MyISAM tables use table locking, so you usually can'
The most obvious is to make sure you are doing bulk inserts, which
you may already be doing.
MyISAM tables use table locking, so you usually can't insert while a
search is occurring. There are a few exceptions and v5 (5.1?) has
another option you can set so inserts are always added to the e
At 04:37 AM 7/30/2007, Octavian Rasnita wrote:
Hi,
I made 2 similar programs that insert data continuously in 2 similar
MyISAM tables, each one in its own table.
Both tables have the same data (3.5 million records), but one of the
tables is update much slower.
The slower table is also access
Hi,
I made 2 similar programs that insert data continuously in 2 similar MyISAM
tables, each one in its own table.
Both tables have the same data (3.5 million records), but one of the tables
is update much slower.
The slower table is also accessed by other programs for getting data from
it.