Hi all,
I have just carried out a mock zend php exam and this question has came up, hope someone can assist:
Which of the following SQL statements will improve SQLite write performance?
1. PRAGMA locking_mode = "Row";
2. PRAGMA count_changes = Off;
3. PRAGMA default_synchronous = Off;
4. PRAGMA default_synchronous = On;
5. PRAGMA locking_mode = "Table";
There are two correct options here.
Best Regards,
Picco
improving SQLite write performance with PRAGMA (Zend Cert)
