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 accessed by other programs for getting data from it.
Is there something I can do to make it faster?
(Using locking, special select queries...)
Or might it work faster if I will use an InnoDB table instead?
Thank you very much.
Octavian
Octavian,
Try running an Optimize on the slow table. How many rows are you
adding? Are you using Load Data or Inserts to add the rows?
Mike
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
