Re: [sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-27 Thread Peter K. Stys
> > > > > > 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

Re: [sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-24 Thread Christian Smith
On Fri, May 23, 2008 at 12:55:47PM -0600, Peter K. Stys wrote: > On Fri, May 23, 2008 at 4:31 AM, Christian Smith < > [EMAIL PROTECTED]> wrote: > > > On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote: > > > Hi Folks: > > > I'm new to this list and just came across a major issue so I

Re: [sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-23 Thread Peter K. Stys
On Fri, May 23, 2008 at 4:31 AM, Christian Smith < [EMAIL PROTECTED]> wrote: > On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote: > > Hi Folks: > > I'm new to this list and just came across a major issue so I thought I'd > > post here: I'm using SQLite (from REALbasic which uses the

[sqlite] Why is SQLite so slow across a network (afp Mac OS X)?

2008-05-13 Thread Peter K. Stys
Hi Folks: I'm new to this list and just came across a major issue so I thought I'd post here: I'm using SQLite (from REALbasic which uses the SQLite DB engine for SQL support) to store image files, and while R/W to local files is excellent, the same operations on files residing on a remote volume