Mysql transaction with Mindquake plugin

[claus707]

Hello to everyone,
I am using Mindquake plugin to access and manage my database.
My issue is that in some cases I have to insert many records and with the command

MySQL.Query("INSERT IGNORE INTO items VALUES(......);");

for every records is very slow.
In this cases transaction can be used, but I don't know how to do this with this plugin.

Could someone give me an example for that?!

[reteset]

take a look at this page

i am not using that plugin but in general , all you need to do is :

MySQL.Query("START TRANSACTION");

for i = 1 ,100 do
   MySQL.Query("INSERT IGNORE INTO table ........");
end

MySQL.Query("COMMIT");

[claus707]

BIG UP for you RETESET
It worked!
I was having some confusion with this plugin because it has two commands
MySQL.AutoCommit() and MySQL.Commit() with no example how to use them...