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

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

we provide hosting service that will provide same performance.
And we can import your existing data.
If you are interrested, contact use through contact form.

I'm sur that is good solution, but for security reason we cannot do that.

is it possible that's the problem is our data server is too slowly ?

Yes of course.

Or maybe just badly configured.

I'm to try to create new empty data base... and restore the data base with backup

I did a new Projeqtor directory name ProjeqtorTest from version 6.4.1,

I'd copy on PhpMyadmin the database and rename,

when I log to the new ProjeqtorTest, I'd the First page configuration, to link the database, password etc...

I'd the connection page, I'm connect, and I have no error message but white page ?????

On console, I have message:
Failed to load resource: the server responded with a status of 404 (Not Found)

So i search little bit more and i have found my mistake. Now i have create a new empty database. Now i will try to dowload on the empty new database my backup of actual database, i hope that it will work and it will go faster. Sorry for my poor english.

Good luck! When everything works, I would very much like to hear what the cause was. Cheers.

so, I did a new folder Projeqtor Test in WWW folder with 6.4.1 version, when I connect on first page, I create a new database name ProjeQtorTest, I can connect it. The new database is ready and empty.
After that, I'm connect to the phpMyadmin, and import the backup of my actually data base.
Now when I'm connect to the projeqtorTest, I've the screen login, I use my login, it's works, but I've a totally white page!

if I go to the console of the browser, I have this (show in attached files)

what's wrong ?

I found the mistake with the log files, I've not install the plugins...

now with plugin the new database is exactly the same as the old one. But exactly the same slowness ...... :dry:

I do not understand ? is it possible to slow database with customization plugin or other plugin ?