Re: [sqlite] baffling performance decrease across network (specific case)

Thank you, that was immensely helpful - as well as Roger Binns many informative posts about OpLocks. Looks like there is nothing to be done about the slowdown (in fact I should be grateful there is even such a thing as opportunistic locking to make the single client situation faster), but it is a

Re: [sqlite] baffling performance decrease across network (specific case)

Serena Lien wrote: > Thanks for the response - no it hadn't occurred to me to try a different > network filesystem, as I don't really have access to non windows machines. > I'm just using windows xp machines set up on the same domain, where the > databases reside on shared folders. > > I actually

Re: [sqlite] baffling performance decrease across network (specific case)

Thanks for the response - no it hadn't occurred to me to try a different network filesystem, as I don't really have access to non windows machines. I'm just using windows xp machines set up on the same domain, where the databases reside on shared folders. I actually thought there might be extra

Re: [sqlite] baffling performance decrease across network (specific case)

On May 20, 2008, at 4:15 PM, Serena Lien wrote: > Thanks for your response. I do realize the performance of sqlite > over the > network will be slower than accessing local databases - I will > restate if I > wasn't clear - the question I asked is why sqlite accessing a > networked >

Re: [sqlite] baffling performance decrease across network (specific case)

Thanks for your response. I do realize the performance of sqlite over the network will be slower than accessing local databases - I will restate if I wasn't clear - the question I asked is why sqlite accessing a networked database is slower WHEN that particular database is attached in a different

Re: [sqlite] baffling performance decrease across network (specific case)

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

[sqlite] baffling performance decrease across network (specific case)

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