Thanks, I will take out the UTF and trace pragma's. synchronous=off is fine as this is only a temp database and not for any permanent storage.
RBS > 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] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
