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
