Steven,
- Original Message -
From: Steven Roussey [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, September 03, 2003 5:31 AM
Subject: InnoDB and lots of UPDATES
I have a question about InnoDB and how it would handle updates on the
order of about 3,000-5,000
Use transaction:
begin
update ...
update ...
...
update ...
commit;
This way you will only have a syncs to disk at every commit instead of
every
update.
This won't help -- I'm not doing a batch process. Each update is coming
from a different connection...
--steve-
--
MySQL
I have a question about InnoDB and how it would handle updates on the
order of about 3,000-5,000 a second. The UPDATEs update a single record
on a primary key. In MySQL, it does a table lock thus serializing the
updates. There are a few selects, though on a couple of orders of
magnitude less