One of the SQL92 features SQLite supports is transactions. This feature can be used to significantly
accelerate applications that need to perform large number of write queries.
<?php
sqlite_query("BEGIN", sqlite_r);
while (($row = fgetcsv($fp, 4096))) {
/* previously seen query code */
}
sqlite_query("COMMIT", sqlite_r);
?>
