Re: [sqlite] Why does a query run 50x slower across a network?

There are several reasons why networks are much slower than local disks (think of SATA vs. Ethernet, SATA Bus vs. Network latency, no client side caching etc.). This is especially true for random access patterns like those SQLite uses. So to minimize file access, (like already suggested by

Re: [sqlite] Why does a query run 50x slower across a network?

t will be much faster. We have a system using SQLite with a SharedDB and connecting that path to a drive is much faster. Ihth. josé -- Adolfo. > > Mensaje original > De: James K. Lowden > Para: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Fecha: Mon, 0

Re: [sqlite] Why does a query run 50x slower across a network?

On Mon, 06 Feb 2017 13:12:22 +0100 a...@zator.com wrote: > In respect to the Windows environment I've appreciated that the use > of UNC convention over a network (LAN) behaves much slower that > "mapping" the logical unit as a drive letter D, E, .. Z in the local > host. That's bizarre. By

Re: [sqlite] Why does a query run 50x slower across a network?

On Mon, Feb 6, 2017 at 4:27 PM, Bart Smissaert wrote: > Would a "server app" be an option, so run SQLite on the remote location and > return the dataset? > Didn't sound like it was, from David's description, but in case I'm guessing wrong, then

Re: [sqlite] Why does a query run 50x slower across a network?

Would a "server app" be an option, so run SQLite on the remote location and return the dataset? RBS On Mon, Feb 6, 2017 at 10:28 AM, dandl wrote: > We have an application we converted from Access to Sqlite. Mostly it's > been a great success, but we have two queries that runs

Re: [sqlite] Why does a query run 50x slower across a network?

-- Adolfo. > > Mensaje original > De: dandl > Para: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> > Fecha: Mon, 6 Feb 2017 11:02:39 +0000 > Asunto: Re: [sqlite] Why does a query run 50x slower across a network? > > On 6 Feb 2017, at 10:28am,

Re: [sqlite] Why does a query run 50x slower across a network?

On 6 Feb 2017, at 10:28am, dandl wrote: > I'm hoping we've done something really dumb and obvious, but we can't see it. > CREATE INDEX [order_header_type_idx] ON [order_header] ([transaction_type], > [sale_type_id]); Nothing really dumb, but this might help. Create another

Re: [sqlite] Why does a query run 50x slower across a network?

I'm in a different environment (linux with database on nfs share) but found the same behaviour. I came to the conclusion that the latency of network file system operations combined with database fragmentation was largely responsible for the reduced performance. SQLite is very seek heavy, unlike a

[sqlite] Why does a query run 50x slower across a network?

We have an application we converted from Access to Sqlite. Mostly it's been a great success, but we have two queries that runs 50x slower across a gigabit LAN than on a local file system and we don't know why. Performance on Access was perfectly acceptable, and on Sqlite is not and we can't