Re: question about the mysql prepare/execute commands

2008-09-02 Thread Jim Lyons
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

Re: question about the mysql prepare/execute commands

2008-09-02 Thread Michael Dykman
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