Hello, I've Fossil repo mostly containing uncompressed Gnucash XML files and commits even for trivial changes are quite slow:
$ time fossil ci -m "update logs" You need a passphrase to unlock the secret key for user: "Gour-Gadadhara Dasa <g...@atmarama.net>" 4096-bit RSA key, ID 52B5C810, created 2011-04-02 New_Version: 6d606bba0322d91e38a5e36541264ff3e9f0036b 24.30user 0.55system 0:27.02elapsed 91%CPU (0avgtext+0avgdata 40804maxresident)k 0inputs+7304outputs (0major+39916minor)pagefaults 0swaps The diff with the previous version (long lines are wrapped) was just adding small *.log file: ------------------------------------- mod trans_guid split_guid time_now date_entered date_posted acc_guid acc_name num description notes memo action reconciled amount value date_reconciled ----------------- ===== START ===== END ===== START ===== END ===== START ===== END ===== START ===== END ===== START ===== END ===== START D 3d73c5e0791e2f4e6ae85c728efc9702 5b5cecdd6785944a87d6beefae4d0746 2014-07-20 13:41:32.000000 +0200 2014-07-20 13:41:32.000000 +0200 2014-07-20 00:00:00.000000 +0200 n 0/1 0/100 1970-01-01 01:00:00.000000 +0100 ===== END ===== START D 13941b1b66123e0d0a487c21022dc2cd df0c47007052f8b1cddb6abc846eceb4 2014-07-20 13:41:52.000000 +0200 2014-07-20 13:41:52.000000 +0200 2014-07-20 00:00:00.000000 +0200 n 0/1 0/100 1970-01-01 01:00:00.000000 +0100 ===== END ===== START D 540642d9cc3486fa01d3c72cf16800b3 13bdd42ca95ba03a36abe86d320099ce 2014-07-20 13:41:52.000000 +0200 2014-07-20 13:41:52.000000 +0200 2014-07-20 00:00:00.000000 +0200 n 0/1 0/100 1970-01-01 01:00:00.000000 +0100 ===== END ===== START D df7895bb0f1855cef57cd747e522ee25 c8a5eda78157df75ef17d93a416985c6 2014-07-20 13:41:52.000000 +0200 2014-07-20 13:41:52.000000 +0200 2014-07-20 00:00:00.000000 +0200 n 0/1 0/100 1970-01-01 01:00:00.000000 +0100 ===== END ===== START D 92528876b4567dad73a7f16e15052207 359d5603f0b281007d91f46bcd56731b 2014-07-20 13:41:52.000000 +0200 2014-07-20 13:41:52.000000 +0200 2014-07-20 00:00:00.000000 +0200 n 0/1 0/100 1970-01-01 01:00:00.000000 +0100 ===== END ----------------------------------------- I wonder if you have any idea what to do in order to speed up commit time? Here is the dbstat output: repository-size: 406535168 bytes (406.5MB) artifact-count: 7071 (stored as 5191 full text and 1880 delta blobs) artifact-sizes: 850325 average, 4800459 max, 6011800801 bytes (6.0GB) total compression-ratio: 14:1 checkins: 973 files: 5843 across all branches wikipages: 0 (0 changes) tickets: 0 (0 changes) events: 0 tagchanges: 18 project-age: 888 days or approximately 2.43 years. project-id: de5578af6cd61b7f042995c2d074bc2667eb2500 server-id: dbd6c972edfd3f6539db54b92adfa4c65e269197 fossil-version: 2014-07-19 19:20:25 [619fa857c9] [1.30] (gcc-4.9.0) sqlite-version: 2014-07-01 11:54:02 [21981e3506] (3.8.6) database-stats: 397007 pages, 1024 bytes/pg, 13 free pages, UTF-8, delete mode Any hint? -- A person who is not disturbed by the incessant flow of desires — that enter like rivers into the ocean, which is ever being filled but is always still — can alone achieve peace, and not the man who strives to satisfy such desires. _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users
