[vbRichClient] RC6 increase SQLite performance

[Mith]

my app scans a lot of files recursively and add/update the file information in the DB.

im searching for some hints/tips/tricks to increase the performance when using a lot of INSERT and SELECT statements.

i already have created all necessary indizies (single+multi) for the columns that i use at the WHERE clause's.

and i already know i have to use .BeginTrans before i start the file scan and using .CommitTrans after the whole scan is completed.
without this SQlite uses a transaction for every INSERT/UPDATE statement and slows down the whole procress

some other web search pointed out to use the following PRAGMA options to speed up the process:

PRAGMA JOURNAL_MODE=OFF
PRAGMA JOURNAL_MODE=WAL
PRAGMA synchronous=OFF
PRAGMA LOCKING_MODE=EXCLUSIVE

See blog.devart: increasing-sqlite-performance.
See JOURNAL_MODE=WAL

Are all these options supported by RC6?

my tweaks so far to improve the performance:

- using .BeginTrans before executing a lot of INSERT/UPDATE statements
- using "LOCKING_MODE=EXCLUSIVE" when executing a lot of SELECT statements
- split the SQL-statement with a table join into 2 SQL-statements

Any other hints/tips/tricks to increase performance using RC6 SQlite?