I'm thinking that the sync call
> is causing the device to write its memory contents back out to disk (ie to be
> persisted). Just a thought...
>
>
>
> --- On Wed, 9/23/09, Pavel Ivanov wrote:
>
>> From: Pavel Ivanov
>> Subject: Re: [sqlite] SQLite datab
Mark Parker-4 wrote:
> This isn't an "SSD". It's connected directly to the PCI Express bus, and
> "low cost" it certainly is NOT. It's much more valuable than the server
> it's plugged into.
Check page size. It might be less than cluster of your ioExtreme. You should
also think about actually t
ie to be persisted).
Just a thought...
--- On Wed, 9/23/09, Pavel Ivanov wrote:
> From: Pavel Ivanov
> Subject: Re: [sqlite] SQLite database on a certain high-performance "SSD"
> To: "General Discussion of SQLite Database"
> Date: Wednesday, September 23, 2009
> Is the only change the absence of a call to "fsync()" when turning
> synchronous off? If so, I can conclusively say that fsync() is very slow
> on this storage device.
Yes, the only action of synchronous = off is to turn off calls to
fsync() which is called at least twice during each commit.
Pa
On a RAID-5 array of 4x SAS disks, turning the sync off made it about 2x
faster, give or take.
On the "SSD", it was about 150x faster.
Is the only change the absence of a call to "fsync()" when turning
synchronous off? If so, I can conclusively say that fsync() is very slow
on this storage de
If you execute
pragma synchronous = off;
you'll be able to compare performance with syncs and without them. So
if you make this comparison on standard spinning disk and on SSD
you'll see if syncs on SSD indeed extra-ordinary slow.
Pavel
On Wed, Sep 23, 2009 at 10:09 AM, Mark wrote:
> It's very
It's very possible, but I don't know how to tell. Is there an easy way
to know if the sync() calls are taking inordinately long?
Mark
Thomas Briggs wrote:
>Is the sync necessary to commit a transaction slow? Performance of
> that sync depends on the OS, file system, hardwar, etc. IIRC, so
Is the sync necessary to commit a transaction slow? Performance of
that sync depends on the OS, file system, hardwar, etc. IIRC, so IOs
may be fast but it's possible that the syncs are killing you.
-T
On Tue, Sep 22, 2009 at 5:14 PM, Mark wrote:
> Lothar Scholz wrote:
>> Hello Mark,
>>
>>
Lothar Scholz wrote:
> Hello Mark,
>
> Tuesday, September 22, 2009, 3:53:48 AM, you wrote:
>
> M> I've currently got a loaner high-performance flash-based "SSD" (let's
> M> just say it doesn't connect to any disk controllers) that I'm testing
> M> for performance. I've run my application agains
Simon Slavin wrote:
> On 22 Sep 2009, at 3:07pm, Ken wrote:
>
>> How is the SSD connected? Could it be an issue with the transport
>> layer to the device?
>
> Also, do you have a storage driver that /knows/ its talking to an
> SSD ? Because some operating systems do all sorts of clever stuff
Hello Mark,
Tuesday, September 22, 2009, 3:53:48 AM, you wrote:
M> I've currently got a loaner high-performance flash-based "SSD" (let's
M> just say it doesn't connect to any disk controllers) that I'm testing
M> for performance. I've run my application against it, and I believe that
M> I shoul
On 22 Sep 2009, at 3:07pm, Ken wrote:
> How is the SSD connected? Could it be an issue with the transport
> layer to the device?
Also, do you have a storage driver that /knows/ its talking to an
SSD ? Because some operating systems do all sorts of clever stuff
(write-queueing, read-ahead
How is the SSD connected? Could it be an issue with the transport layer to the
device?
--- On Mon, 9/21/09, Dave Toll wrote:
> From: Dave Toll
> Subject: Re: [sqlite] SQLite database on a certain high-performance "SSD"
> To: "General Discussion of SQLite Database&quo
SSDs aren't necessarily faster than disks:
http://en.wikipedia.org/wiki/Solid-state_drive#Disadvantages
- Original Message -
From: "Mark"
To:
Sent: Monday, September 21, 2009 1:53 PM
Subject: [sqlite] SQLite database on a certain high-performance "SSD"
>
On Mon, Sep 21, 2009 at 1:53 PM, Mark wrote:
> I've currently got a loaner high-performance flash-based "SSD" (let's
> just say it doesn't connect to any disk controllers) that I'm testing
> for performance. I've run my application against it, and I believe that
> I should see numbers MUCH higher
al Message-
From: Mark [mailto:godef...@gmail.com]
Sent: 21 September 2009 13:54
To: sqlite-users@sqlite.org
Subject: [sqlite] SQLite database on a certain high-performance "SSD"
I've currently got a loaner high-performance flash-based "SSD" (let's
just say it doesn
I've currently got a loaner high-performance flash-based "SSD" (let's
just say it doesn't connect to any disk controllers) that I'm testing
for performance. I've run my application against it, and I believe that
I should see numbers MUCH higher than I do. When I run my test app on a
normal SATA
17 matches
Mail list logo