RB Smissaert wrote:
'these speed up inserts enormously, particulary the first one
'------------------------------------------------------------
sqlite_get_table lDBHandle, "PRAGMA synchronous=off;", strErrors
sqlite_get_table lDBHandle, "PRAGMA encoding='UTF-8';", strErrors
'not sure default_cache_size applies to a memory database, probably not
If bFile Then
sqlite_get_table lDBHandle, _
"PRAGMA default_cache_size = 32768;", strErrors
End If
sqlite_get_table lDBHandle, "PRAGMA vdbe_trace = OFF;", strErrors
sqlite_get_table lDBHandle, "PRAGMA page_size=4096;", strErrors
You might want to be careful with this code. The first pragma above
turns off synchronous disk I/O so your database is subject to corruption
by a power failure. The second sets the encoding to its default value,
UTF-8, and shouldn't be needed. The second last (vdbe_trace) is also
setting the value to its default. Furthermore this pragma can only be
turned on in a special debug build of the sqlite dll. Increasing the
cache and page size will speed up your code safely if you have the
memory to spare.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
