Re: [fossil-users] fossil slow on binary file changes

2009-03-26 Thread Rene Zaumseil
> From: "D. Richard Hipp" > Subject: Re: [fossil-users] fossil slow on binary file changes, reason > and workaround > To: fossil-users@lists.fossil-scm.org > Message-ID: <17c6a27d-07aa-4d68-8682-6bbe78155...@hwaci.com> > Content-Type: text/plain; char

Re: [fossil-users] fossil slow on binary file changes, reason and workaround

2009-03-24 Thread D. Richard Hipp
On Mar 24, 2009, at 3:40 AM, Rene Zaumseil wrote: > Hi, > > using larger binary files takes some time in fossil. > The first commit is really fast. After that, the time is spent > in function content_deltify(). The issue here was that the delta generator was inefficient when given two large f

Re: [fossil-users] fossil slow on binary file changes, reason and workaround

2009-03-24 Thread Eric
On Tue, March 24, 2009 7:40 am, "Rene Zaumseil" wrote: > > using larger binary files takes some time in fossil. > The first commit is really fast. After that, the time is spent > in function content_deltify(). > > A fast workaround is: > 1. fossil rm > 2. fossil commit > 3. fossil add >

[fossil-users] fossil slow on binary file changes, reason and workaround

2009-03-24 Thread Rene Zaumseil
Hi, using larger binary files takes some time in fossil. The first commit is really fast. After that, the time is spent in function content_deltify(). A fast workaround is: 1. fossil rm 2. fossil commit 3. fossil add 4. fossil commit Thanks for your responses and help. Regards rene __

Re: [fossil-users] fossil slow on binary file changes

2009-03-19 Thread Eric
On Thu, March 19, 2009 1:33 pm, "D. Richard Hipp" wrote > > Somebody once suggested that I add a new command to fossil that lets > you enter raw SQL against the repository database file. In other > words, build the functionality of the "sqlite3" CLI into fossil. I > rejected the idea at the time

Re: [fossil-users] fossil slow on binary file changes

2009-03-19 Thread D. Richard Hipp
On Mar 19, 2009, at 9:26 AM, D. Richard Hipp wrote: > > On Mar 19, 2009, at 9:17 AM, Rene Zaumseil wrote: >> >> 4. drh's tip failed >> sqlite3 t.fsl 'pragma page_size=16384; vacuum' >> SQL error: SQL logic error or missing database >> >> sqlite3 >> SQLite version 3.2.8 > > 3.2.8? Wow. That's *r

Re: [fossil-users] fossil slow on binary file changes

2009-03-19 Thread D. Richard Hipp
On Mar 19, 2009, at 9:17 AM, Rene Zaumseil wrote: > > 4. drh's tip failed > sqlite3 t.fsl 'pragma page_size=16384; vacuum' > SQL error: SQL logic error or missing database > > sqlite3 > SQLite version 3.2.8 3.2.8? Wow. That's *really* old. Can you try again with a more recent version of SQ

Re: [fossil-users] fossil slow on binary file changes

2009-03-19 Thread Rene Zaumseil
Hi, some additional infos to the test case with file test/t.tgz: 1. Create fossil new t.fsl project-id: cc61147ca74309335780e376498e4ee10cdb535b server-id: 4c123bb92b482882c970d43357ec9bc9e1a46b33 admin-user: rene (initial password is "f6fb86") 2. Init cd test fossil open ../t.fsl fossi

Re: [fossil-users] fossil slow on binary file changes

2009-03-19 Thread D. Richard Hipp
On Mar 19, 2009, at 6:46 AM, Kees Nuyt wrote: > On Thu, 19 Mar 2009 10:03:26 +0100, you wrote: > >> Hi, >> >> I would use a binary (*.tgz) file in my repository. The file is >> near 20 MB. >> The first add is immediately. After changing the file, the commit >> takes >> nearly half an hour? >>

Re: [fossil-users] fossil slow on binary file changes

2009-03-19 Thread Kees Nuyt
On Thu, 19 Mar 2009 10:03:26 +0100, you wrote: >Hi, > >I would use a binary (*.tgz) file in my repository. The file is near 20 MB. >The first add is immediately. After changing the file, the commit takes >nearly half an hour? > >Test case with file test/t.tgz: > fossil new t.fsl > cd test > fos

[fossil-users] fossil slow on binary file changes

2009-03-19 Thread Rene Zaumseil
Hi, I would use a binary (*.tgz) file in my repository. The file is near 20 MB. The first add is immediately. After changing the file, the commit takes nearly half an hour? Test case with file test/t.tgz: fossil new t.fsl cd test fossil open ../t.fsl fossil add t.tgz # change file t.tgz