complement: the slowness is during the recordings, such as imputations, backup of activities, change of status ...

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

Computer of ProjeQtor Database is only use for this application, it's a quad core with 16G Ram.

Data base is 150 projects, 1250 activities , 100 tickets, no periodic meeting...

I just have more delay for registration as usual...

Just for information:

When I create new activity, it's take around 45 seconds to record it.

when I change the status of activity, it's take 34 seconds

When I record the modification of RealWork sheet: around 40 seconds.

all of recording take more time...

More than 3s to save an activity is not normal.
First check lock file for errors.
I guess you have email issue.
Try and clear parameter "smtp server" in global parameters. Disconnect, reconnect and test again.
Tell us if it's better.

This log file for today:

2017-10-04 10:36:56.825 ===== TRACE ===== NEW CONNECTED USER 'jop'
2017-10-04 10:54:13.633 ===== TRACE ===== NEW CONNECTED USER 'fca'
2017-10-04 11:03:43.805 ===== TRACE ===== NEW CONNECTED USER 'par'
2017-10-04 11:07:04.536 ** ERROR ** [V6.4.1] ERROR **
2017-10-04 11:07:04.536 ** ERROR ** [V6.4.1] on file '/var/www/projeqtor/view/objectStream.php' at line (38)
2017-10-04 11:07:04.536 ** ERROR ** [V6.4.1] cause = Undefined property: Work::$idle
2017-10-04 11:07:04.900 ** ERROR ** [V6.4.1] ERROR **
2017-10-04 11:07:04.900 ** ERROR ** [V6.4.1] on file '/var/www/projeqtor/tool/jsonQuery.php' at line (691)
2017-10-04 11:07:04.901 ** ERROR ** [V6.4.1] cause = Undefined variable: dateWeekOrMonthOrYear
2017-10-04 11:09:08.827 ** ERROR ** [V6.4.1] ERROR **
2017-10-04 11:09:08.827 ** ERROR ** [V6.4.1] on file '/var/www/projeqtor/view/objectStream.php' at line (38)
2017-10-04 11:09:08.827 ** ERROR ** [V6.4.1] cause = Undefined property: Work::$idle
2017-10-04 11:09:09.137 ** ERROR ** [V6.4.1] ERROR **
2017-10-04 11:09:09.137 ** ERROR ** [V6.4.1] on file '/var/www/projeqtor/tool/jsonQuery.php' at line (691)
2017-10-04 11:09:09.137 ** ERROR ** [V6.4.1] cause = Undefined variable: dateWeekOrMonthOrYear
2017-10-04 11:25:17.807 ===== TRACE ===== DISCONNECTED USER 'pma'
2017-10-04 11:25:23.871 ===== TRACE ===== NEW CONNECTED USER 'pma'

this is Global parameter for Email:

Log file Yesterday:

2017-10-03 14:47:45.586 ===== TRACE ===== Login error for user ''
2017-10-03 14:47:47.476 ===== TRACE ===== NEW CONNECTED USER 'JRI'
2017-10-03 14:47:58.589 ===== TRACE ===== DISCONNECTED USER 'dep'
2017-10-03 15:01:30.033 ===== TRACE ===== NEW CONNECTED USER 'dep'
2017-10-03 15:01:35.433 ===== TRACE ===== Cron started at 03/10/2017 15:01:35
2017-10-03 15:22:08.501 ===== TRACE ===== NEW CONNECTED USER 'GKR'
2017-10-03 15:31:54.308 ===== TRACE ===== DISCONNECTED USER 'dep'
2017-10-03 15:31:58.725 ===== TRACE ===== NEW CONNECTED USER 'dep'
2017-10-03 15:35:53.645 ===== TRACE ===== NEW CONNECTED USER 'sba'
2017-10-03 15:39:06.642 ===== TRACE ===== NEW CONNECTED USER 'ASE'
2017-10-03 15:42:34.856 ===== TRACE ===== DISCONNECTED USER 'ASE'
2017-10-03 15:42:54.157 ===== TRACE ===== NEW CONNECTED USER 'LOL'
2017-10-03 15:42:59.472 ===== TRACE ===== Cron started at 03/10/2017 15:42:59
2017-10-03 15:48:15.952 ===== TRACE ===== DISCONNECTED USER 'sba'
2017-10-03 15:56:25.712 ===== TRACE ===== NEW CONNECTED USER 'msi'
2017-10-03 16:23:49.979 ===== TRACE ===== DISCONNECTED USER 'dep'
2017-10-03 16:23:52.444 ===== TRACE ===== NEW CONNECTED USER 'dep'
2017-10-03 16:25:45.836 ** ERROR ** [V6.4.1] save Data to session : Invalid id value - [displayByStatusList_Activity]
2017-10-03 16:27:08.911 ** ERROR ** [V6.4.1] save Data to session : Invalid id value - [displayByStatusList_Activity]
2017-10-03 17:13:31.122 ===== TRACE ===== Logfile->purge() : Technical trace to keep current log file
2017-10-03 17:49:17.839 ===== TRACE ===== NEW CONNECTED USER 'ASE'
2017-10-03 18:06:02.222 ===== TRACE ===== DISCONNECTED USER 'ASE'
2017-10-03 19:09:52.224 ===== TRACE ===== DISCONNECTED USER 'dep'
2017-10-03 19:20:58.401 ===== TRACE ===== DISCONNECTED USER 'jop'

Maybe it is the connection to the smtp server that is very long.
(sending of emails is synchronous, so may slow down response for saving operations that sends email)

Please try and clear smtp server parameter.
This will diable email sending.
Then test again for performance and tell us if it's better.

Error shown is log file make le guess you have some cache issue.
Try and clean browser cache ...
(but this does not have any impact on performance : see previous request)

so, I erase cache of my browser.
I deleted all fields of mail in global parameter.

on activity created, I just put 8h on assignment and push record button, it's take 40s.

You sure have perf issue, but I cannot guess where it comes from...
I just tried on Demo, and saving took less than 0.4 seconds.
Can you try on demo same use case and confirm there is no issue here ?

what is demo ?

Ok I found demo data base,

I create the #85 activity, It's very very fast, instantly !!!!

I would my data base same as demo !!! please