[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Monotone-devel] ideas to speed up monotone SQLite database access
From: |
Timothy Brownawell |
Subject: |
Re: [Monotone-devel] ideas to speed up monotone SQLite database access |
Date: |
Sun, 05 Feb 2006 16:56:32 -0600 |
On Sun, 2006-02-05 at 14:39 -0800, Joe Wilson wrote:
[...]
> (2) Use a ":memory:" database for the initial monotone pull and then dump the
> resultant database
> to file. This would eliminate the disk latency entirely. Since most monotone
> databases I've seen
> are generally under 100 megs, this is a viable option. Naturally, the
> file-based database must be
> locked during the entire pull/dump operation. Unfortunately, this would
> prevent more than one user
> from accessing the database at a time.
>
> http://www.sqlite.org/cvstrac/wiki?p=InMemoryDatabase
The new netsync code allows a pull to be interrupted without losing
what's already been downloaded. So if an impatient user hits ^C (or the
system crashes, or...) after 10 minutes, the next time they try to pull
they don't have to re-pull the part that they pulled in those 10
minutes. Wouldn't keeping everything in memory kill this feature?
Tim
- [Monotone-devel] ideas to speed up monotone SQLite database access, Joe Wilson, 2006/02/05
- Re: [Monotone-devel] ideas to speed up monotone SQLite database access, Daniel Carosone, 2006/02/05
- Re: [Monotone-devel] ideas to speed up monotone SQLite database access,
Timothy Brownawell <=
- Re: [Monotone-devel] ideas to speed up monotone SQLite database access, Matt Johnston, 2006/02/06
- Re: [Monotone-devel] ideas to speed up monotone SQLite database access, Joe Wilson, 2006/02/06
- Re: [Monotone-devel] ideas to speed up monotone SQLite database access, Nathaniel Smith, 2006/02/07
- Re: [Monotone-devel] ideas to speed up monotone SQLite database access, Brian Downing, 2006/02/07
- Re: [Monotone-devel] ideas to speed up monotone SQLite database access, Nathaniel Smith, 2006/02/07
- [Monotone-devel] reiser for monotone?, hendrik, 2006/02/07
- [Monotone-devel] Re: reiser for monotone?, Bruce Stephens, 2006/02/07
- Re: [Monotone-devel] reiser for monotone?, Chad Walstrom, 2006/02/07
- Re: [Monotone-devel] reiser for monotone?, Nathaniel Smith, 2006/02/07