On Tue, May 20, 2008 at 9:43 AM, Serena Lien <[EMAIL PROTECTED]> wrote:
> Hello, > > I wonder if anyone could shed some light on this. I am using sqlite in my > client programs to access databases over the network. I know sqlite isn't > recommended for this usage model, but I am happy that I have implemented it > such that only 1 client ever has write access, and am also happy with the > performance (speed) over the network in normal situations. > I posted a query on this list very recently about a similar issue, except I noticed a 20-fold decrease in R/W performance across the network with a single connection (BLOB access), compared to what you get with a binary file R/W. Cogent explanations were given, and I conclude that SQLite (and perhaps all non-backend-server based solutions will suffer greatly across a network vs. local volume). I had to rejig my app so that remote SQLite files are first copied to a local temp file, operated on, then copied back to remote volume. I can't see any other way. Peter. -- --------------------------------------------- Peter K. Stys, MD Dept. of Clinical Neurosciences Hotchkiss Brain Institute University of Calgary tel (403) 210-8646 --------------------------------------------- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users