Gives a better out of box experience for people with more powerful machines.

change default value of PAGE_SIZE from 2048 to 4096 to more closely match most filesystems block size.

MVStore: the store is now auto-compacted automatically up to some point, to avoid very large file sizes. This area is still work in progress.

Introduce a queue when doing table locking to prevent session starvation.

don't lock the META table in verifyMetaLocked(), since we're just going to throw an exception if it wasn't locked already

some minor renaming and code movement around table locking to make it easier for me to follow the code

Sequences of temporary tables (auto-increment or identity columns) were persisted unnecessarily in the database file, and were not removed when re-opening the database.

Rename "updateOrInsert" back to "update", because it could also be "delete", or changing a setting, or running system command. "update" and "query" are the same terms used as in "Statement.executeUpdate" and "Statement.executeQuery".

Sequences of temporary tables (auto-increment or identity columns) were persisted unnecessarily in the database file, and were not removed when re-opening the database.