I don't have an answer, but I am also a newb and also very interested in performance. I am getting adequate performance but that is with only one simultaneous user (me) and a practically empty database. Can you describe your system for comparison? What is your hardware spec? How "big" is your ProjeQtOr database? Has the system become slower over time? I.e. was it fast enough "before", and now it isn't?
My system is ProjeQtor 6.4.1 on older consumer-grade hardware:
- Intel Core 2 Duo E6600 2.4GHz (4MB L2 cache, 1066MHz FSB) with 3G RAM
- FreeBSD 10.3 (cli only)
- Apache 2.4.27
- MariaDb 10.0.32
- PHP 5.6.31
- Internet via DCSIS Cable modem (15 Mbs limit to internet)
I also found some relatively recent relevant posts:
Performance Issue on generating and deleting periodic meetings
. It seems reasonable performance for the reported "Generating a periodic meetings with 200 entries takes on our server about 10 min. Deleting the complete periodic meeting took about 8 hours.". It's interesting that the same test was reportedly faster on the ProjeQtOr demo server (generating 2 min, deleting 1:30 hours), but it's not clear if this is understable due to faster hardware, or if other measures (e.g. caching are involved,
Hardware configuration
. @babynus reported a "Good PC" with quad-core processor and 8 GB RAM (twice mine in both respects!) should be adequate for 400 projects and 3000 activities, and reports a successful site having "800 users, with 200-400 daily connections" (however, he also says "One issue has been reported on Gantt printing"). @babynus also says "think about clustering for high level platform".
Users and memory size
. @babynus reported that "...display of Gantt of hundreds of lines in a browser may be much CPU and Memory consuming for your workstation." Chrome is suggested, but it is not clear if ProjeQtOr runs faster on Chrome for some technical reasons.
(sorry if I mixed up any of the links). I'm especially interested in whether there are any "rules of thumb" for size and system configuration? At what "size" does database clustering likely become necessary? What about clustering and load balancing apache http servers?
Thanks,
Dale