the table is myisam, so anything having to do with transactions won't have
any effect.
On Tue, Sep 2, 2008 at 4:54 PM, Michael Dykman <[EMAIL PROTECTED]> wrote:
> To hazard a guess here: the mysql console typically starts up in
> autocommit mode. The neccesity of commiting after each
> statement
To hazard a guess here: the mysql console typically starts up in
autocommit mode. The neccesity of commiting after each
statement/execution could be costing you some cycles.
What is the table type of your test data? I would not expect
transactions in MyISAM would give you any beifit but under an
I have a question about the prepare/execute commands provided by mysql.
I devised a benchmark, comparing updating a table using a
statement-at-a-time versus using a prepare/execute pair. The table had a
million rows.
The statement-at-a-time file looked like:
reset query cache;
update company se
