> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Stephen Chrzanowski
> Sent: woensdag 28 mei 2014 17:33
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Load time performance
>
Caching or not, I don't experience the same thing with opening a read only
text file in Notepad. For S'n'Gs, I had a random text file sitting on my
desktop (A config file for a game, and it is pure text) and decided to use
it as a subject of abuse. Its original attribute is set so read only is
OF
On 28 May 2014, at 1:44pm, Stephen Chrzanowski wrote:
> What I found was that even changing the files read-only attribute
> (Old-school DOS 3.3 days file attribute kinda thing) the initial query lag
> hit. The same thing happened when I unset the R/O attrib and set the NTFS
> permissions to rea
Read Only mode is going to cause initial lag. I've written an analysis to
what I saw at least on a Windows machine several months ago. I didn't try
a Linux machine I don't think, but I can re-do it if anyone is interested.
That analysis was done on a local drive (RAID-0 SSD setup), not on a
netwo
HR> To: General Discussion of SQLite Database
HR> Subject: Re: [sqlite] Load time performance
HR> You shouldn't access a SQLite database remotely, except maybe for
HR> read only access, but that could come under fire. Any network
HR> file action can't guarantee that write locks
Rinat
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Stephen Chrzanowski
Sent: Thursday, May 22, 2014 4:05 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Load time performance
You shouldn't acces
On 22 May 2014, at 1:12pm, Hadashi, Rinat wrote:
> The first time I access a database takes significantly more time than
> subsequent accesses.
> I am looking for ideas to shorten the time required for the first access.
Access it before you need it.
You understand that the first access needs
You shouldn't access a SQLite database remotely, except maybe for read only
access, but that could come under fire. Any network file action can't
guarantee that write locks happen.
If you attempt to access a file in READ-ONLY mode, you'll be greeted with a
1-5 second delay (I don't remember what
Hi
The first time I access a database takes significantly more time than
subsequent accesses.
I am looking for ideas to shorten the time required for the first access.
I work on Linux, my db. file is "somewhere" in the file system, not locally on
the machine from which I am running sqlite3
Tha
9 matches
Mail list logo