> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of David de Regt
> Sent: vrijdag 30 november 2012 18:41
> To: General Discussion of SQLite Database
> Subject: [sqlite] Windows (slow) vs. iOS/OSX
You said that other people tested it, and verified it, so it's unlikely
that an Antivirus (or some other software - Inventory, or something
similar) might be problematic.
Another thing you can do is to fire up procmon (SysInternals) and watch
writes to your db. - they would happen from your
...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Roger Binns [rog...@rogerbinns.com]
Sent: Friday, November 30, 2012 2:00 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 30/11/12 13:31, David de Regt wrote:
> Only possible agent is MSE,
MSE is the best behaved. Norton and similar are especially bad.
> ... and process monitor doesn't show it eating IO
Sadly that rules out easy fixes :-)
> I tried changing block
up by ~5%.
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Roger Binns [rog...@rogerbinns.com]
Sent: Friday, November 30, 2012 1:14 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Windows (slow) vs. iOS/OSX (fast
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 30/11/12 09:41, David de Regt wrote:
> Is there something ridiculous about the windows file system performance
> that hoses sqlite's open/read/write/close transaction cycle?
There are multiple possible confounding factors. One is that you could
>260ms).
-David
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of Simon Slavin [slav...@bigfraud.org]
Sent: Friday, November 30, 2012 10:33 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Windows (slow) vs
;
DdR> From: sqlite-users-boun...@sqlite.org
DdR> [sqlite-users-boun...@sqlite.org] on behalf of Black, Michael (IS)
[michael.bla...@ngc.com]
DdR> Sent: Friday, November 30, 2012 9:46 AM
DdR> To: General Discussion of SQLite Database
DdR> Subjec
On 30 Nov 2012, at 5:41pm, David de Regt wrote:
> Basic query set:
> CREATE TABLE test (col1 int, col2 text);
> [loop 500 times]: INSERT INTO TEST (col1,col2) VALUES (4,'test4')
I read with interest the figures you produced so far, though I have no
explanation. Can I ask
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of David de Regt [dav...@mylollc.com]
Sent: Friday, November 30, 2012 11:50 AM
To: General Discussion of SQLite Database
Subject: EXT :Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance
Nope, I ran the tests
Subject: Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance
Could this be your problem?
http://mattgadient.com/2011/02/18/mac-os-x-slow-for-10-15-minutes-after-boot-the-fix/
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop
From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on
behalf of David de Regt [dav...@mylollc.com]
Sent: Friday, November 30, 2012 11:41 AM
To: General Discussion of SQLite Database
Subject: EXT :[sqlite] Windows (slow) vs. iOS/OSX (fast) Performance
Hey all. I've been
It's not your problem.
If the idiot user wants a slow machine, that's his choice.
It certainly isn't your job to turn off sync in order to hide how slow Windows
is.
On 30 Nov 2012, at 17:41, David de Regt wrote:
> Hey all. I've been struggling with a basic perf issue
Hey all. I've been struggling with a basic perf issue running the same code on
Windows vs. iOS and OSX.
Basic query set:
CREATE TABLE test (col1 int, col2 text);
[loop 500 times]: INSERT INTO TEST (col1,col2) VALUES (4,'test4')
I'm coding this using the default C amalgamation release and using
14 matches
Mail list logo