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);
?>