>
>
> >
> > BTW, those PRAGMAs made little difference. I resorted to caching the
> remote
> > file to the local drive via a fast OS-level file copy then doing the SQL
> > R/W, then copying back to the remote in a bkgnd thread. A programming
> > headache to keep everything in sync, but very acceptable performance.
>
>
> Actually, you might want to try using a larger page size. SQLite uses, by
> default, 1KB pages. Increasing that to 16KB or perhaps larger will not
> only reduce the overhead of BLOBs, but also increase performance
> significantly, as each page will be going across the network one by one.
>
Tried that too (I believe I set to the max of 32KB) with little improvement.
In fact I had:
PRAGMA page_size = SQLITE_MAX_PAGE_SIZE
PRAGMA cache_size = 1000000
PRAGMA synchronous = OFF
With little improvement.
P.
--
---------------------------------------------
Peter K. Stys, MD
Dept. of Clinical Neurosciences
Hotchkiss Brain Institute
University of Calgary
tel (403) 210-8646
---------------------------------------------
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
