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 oth
rive and it 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
> Fecha: Mon, 06 Feb 2017
> Asunto: Re
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 mapp
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 https://github.com/rqlite/rqlite might be of intere
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 50x slower acros
tuations.
--
Adolfo.
>
> Mensaje original
> De: dandl
> Para: SQLite mailing list
> 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, dandl wrote:
>We have an applica
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 two indexes with
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 f
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 figu
9 matches
Mail list logo