Re: shared memory

[prev] [thread] [next] [Date index for 2005/03/15]

From: Dan Sully
Subject: Re: shared memory
Date: 19:53 on 15 Mar 2005

* Perrin Harkins shaped the electrons to say...

>On Tue, 2005-03-15 at 14:11 -0500, Jonathan Vanasco wrote:
>> sqlite3 is closer in speed to bdb than mysql, and offers more of the 
>> 'accessibility' that mysql offers.
>> i find myself using it much more than bdb lately
>
>SQLite2 was pretty slow when I benchmarked it for simple hash-like
>usage.  MySQL beat it by miles.  If the new one is faster, I'll have to
>try my benchmarks again.  Does it do anything fancier for concurrency
>than locking the whole database like the older versions did?

We're finding that sqlite3 / DBD::SQLite is much faster than MySQL now.

It has a slightly better locking system, where you can upgrade the locks to
an exclusive writer and many readers. But it still locks the whole database.

-D
        -- 
        <dr.pox> what're the units of the coefficient of agnosticity? I don't knows per hour?

(message missing)

shared memory
=?ISO-8859-1?Q?Andr=E9_Warnier?= 16:35 on 15 Mar 2005

Re: shared memory
Jonathan Vanasco 16:37 on 15 Mar 2005

Re: shared memory
=?ISO-8859-1?Q?Andr=E9_Warnier?= 17:07 on 15 Mar 2005

Re: shared memory
=?ISO-8859-1?Q?Andr=E9_Warnier?= 22:53 on 15 Mar 2005

Re: shared memory
Martin Moss 17:47 on 15 Mar 2005

Re: shared memory
Perrin Harkins 18:04 on 15 Mar 2005

Re: shared memory
Jonathan Vanasco 19:11 on 15 Mar 2005

Re: shared memory
Perrin Harkins 19:48 on 15 Mar 2005

Re: shared memory
Dan Sully 19:53 on 15 Mar 2005

Re: shared memory
jonathan vanasco 00:30 on 17 Mar 2005

Re: shared memory
Jonathan Vanasco 20:05 on 15 Mar 2005

Re: shared memory
Perrin Harkins 20:14 on 15 Mar 2005

Re: shared memory
=?ISO-8859-1?Q?Andr=E9_Warnier?= 22:26 on 15 Mar 2005

Re: shared memory
Perrin Harkins 22:31 on 15 Mar 2005

Re: shared memory
=?ISO-8859-1?Q?Andr=E9_Warnier?= 23:26 on 15 Mar 2005

Re: shared memory
Jonathan Vanasco 23:40 on 15 Mar 2005

Re: shared memory
Eric Wilhelm 23:50 on 15 Mar 2005

Re: shared memory
Perrin Harkins 00:29 on 16 Mar 2005

Re: shared memory
Scott Gifford 03:29 on 16 Mar 2005

Re: shared memory
William McKee 14:36 on 18 Mar 2005

Re: shared memory
Perrin Harkins 00:30 on 16 Mar 2005

Re: shared memory
jonathan vanasco 00:40 on 16 Mar 2005

Re: shared memory
Perrin Harkins 00:50 on 16 Mar 2005

Re: shared memory
Ofer Nave 01:20 on 16 Mar 2005

Re: shared memory
jonathan vanasco 01:56 on 16 Mar 2005

Re: shared memory
Perrin Harkins 01:06 on 17 Mar 2005