On Thu, Dec 18, 2014 at 11:47:43AM -0500, Richard Hipp wrote: > Martin & Baruch: > > Thanks for stress-testing Fossil! I don't have any repositories that are > quite > that big. In fact, yours appear to be about 100x larger than any that I test > with. This means that you are much more likely to hit performance issues, > sooner, than I do. > > Please do watch for pages that are slow to generate, and let me know what > those > pages are. > > On the footer of each page there is (by default - unless you have changed it) > a > line that says how much time was required to generate the page on the server. > I'm interested to know how much time was used to generate some of your > multi-megabyte /tree pages.
For this particular repo: The : /tree?ci=tip&mtime=1 page I get: This page was generated in about 2.057s Here's the /stat of this repo: --------------------------------------------------------------------- Repository Size: 2194643968 bytes (2.2GB) Number Of Artifacts: 78035 (56344 fulltext and 21691 deltas) Uncompressed Artifact Size: 208841 bytes average, 104499200 bytes max, 16296705044 bytes (16.3GB) total Compression Ratio: 7:1 Number Of Check-ins: 883 Number Of Files: 147965 Number Of Wiki Pages: 2 Number Of Tickets: 9 Duration Of Project: 829 days or approximately 2.27 years. Project ID: 20b326b473b08ee3115aeb5005ea65b5cd68e84b Server ID: 73434698d3f0fec065302eebc544085c93a34c98 Fossil Version: 2014-12-18 09:38:02 [87185aa5dd] (1.30) [compiled using gcc-4.7.2] SQLite Version: 2014-12-10 04:58:43 [3528f8dd39] (3.8.8) Repository Rebuilt: 2014-04-11 04:16:28 By Fossil 1.28 [1762a72f0e] 2014-04-10 08:36:18 UTC Database Stats: 2143207 pages, 1024 bytes/page, 4045 free pages, UTF-8, delete mode --------------------------------------------------------------------- Talking about stressing fossil, I notice this repo work much faster under linux compared with windows on comparable machine. Both are core-i7, but my linux computer have a slower Seagate Barracuda LP 2TB hard disk while my windows computer use a fast SSD drive. Example using fossil "status: command: Linux (debian 7 64bit): $ time fossil status real 0m1.220s user 0m0.288s sys 0m0.272s Windows (windows 8.1 64bit 32bit build using mingw): $ time fossil status real 0m9.981s user 0m0.000s sys 0m0.062s I wonder why there's so much differences.. On a older core-2 computer with windows, it even take more than 1 minute. (I don't have a comparison with linux on same computer..) -- Martin G. _______________________________________________ fossil-users mailing list fossil-users@lists.fossil-scm.org http://lists.fossil-scm.org:8080/cgi-bin/mailman/listinfo/fossil-users