Re: [sqlite] shared-cache mode and firefox

2006-12-06 Thread Jay Sprenkle

Thanks Vitali, and Trevor. I'll poke them instead ;)


> Firefox is now using sqlite. They use shared-cache mode because they want it
> to work over networked drives and they don't want to pay for the
> latency involved.

The "shared cache mode" in sqlite only changes certain behavior for
threads in the same process.  It's unrelated to external locks, which
work as normal.  It's my understanding that Firefox has done
modifications of their own to disable external locking.



--
The JS Image Collector suite:
http://groups-beta.google.com/group/js-image-collector?hl=en

SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] shared-cache mode and firefox

2006-12-06 Thread Trevor Talbot

On 12/6/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:


Firefox is now using sqlite. They use shared-cache mode because they want it
to work over networked drives and they don't want to pay for the
latency involved.


The "shared cache mode" in sqlite only changes certain behavior for
threads in the same process.  It's unrelated to external locks, which
work as normal.  It's my understanding that Firefox has done
modifications of their own to disable external locking.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



Re: [sqlite] shared-cache mode and firefox

2006-12-06 Thread Vitali Lovich

http://www.sqlite.org/sharedcache.html

It's controlled at runtime by the function

int sqlite3_enable_shared_cache(int);

Thus that behaviour is probably controlled by Firefox (assuming it uses a 
version of sqlite with cache support compiled in).  You'd have to ask them.


Jay Sprenkle wrote:

Good evening,

I'd like to make a request for the next version of sqlite.
It's a big change and will probably get shot down, but you won't know
until you ask.

Firefox is now using sqlite. They use shared-cache mode because they 
want it

to work over networked drives and they don't want to pay for the
latency involved.
I personally wouldn't have made this choice since it trades away
something I think
that could be useful to a large number of people to support something
that I believe
almost nobody will use. It's not my decision though. If shared-cache 
mode was

something that could be turned off at run time it would allow everyone
to get what
they want. I believe this would be a complete refactoring of the code 
though.


Thanks for your time Dr. Hipp, and for sharing Sqlite with all of us!

Jay



-
To unsubscribe, send email to [EMAIL PROTECTED]
-



[sqlite] shared-cache mode and firefox

2006-12-06 Thread Jay Sprenkle

Good evening,

I'd like to make a request for the next version of sqlite.
It's a big change and will probably get shot down, but you won't know
until you ask.

Firefox is now using sqlite. They use shared-cache mode because they want it
to work over networked drives and they don't want to pay for the
latency involved.
I personally wouldn't have made this choice since it trades away
something I think
that could be useful to a large number of people to support something
that I believe
almost nobody will use. It's not my decision though. If shared-cache mode was
something that could be turned off at run time it would allow everyone
to get what
they want. I believe this would be a complete refactoring of the code though.

Thanks for your time Dr. Hipp, and for sharing Sqlite with all of us!

Jay

--
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-