Re: Utilize maximum system resources for better performance

[Ronald Brown]

whats the difference in mysqli_begin_transaction and mysqli_autocommit ?

mysqli_autocommit($conn,FALSE);//takes 22.289810597897 minutes

mysqli_begin_transaction($conn);//takes 18.555663919449 minutes

which is better and why ?

you said `autocommit is local to your sessions` , does this mean mysqli_begin_transaction will stop all other writes to same table ? or something like that ?

i am going to use this in php file which will run by cronjob.

Thanks