Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.
Hello babynus,
This is I realize a rather generic question, but i'm asking just in case you would have some ideas, as I believe you have much more experience than I do on this type of application !
I am in the process of searching for ways to optimize performance on my projeqtor setup (the DB is getting very large).
One thing I'"ve noticed while doing measurements on different actions is that sometimes I get huge variations in timing when repeating the same action several times. (and it's not that the second time is much faster, which could be explained by caching - it seems very random). I can do a simple action which will take 3 seconds the first time, and get stuck for 20 seconds another time...
So I'm just wondering if you have any ideas as to what could cause this type of thing / what direction to search in ?
Thanks in any case !
Hi,
Very complexe question...
Fist you should try to identify source of lag : PHP server, MySql Sever, Network...
For instance, adding some traces, to get information about where the difference in execution time is.
Also check for machine status (on linux a Top will do the job) to check CPU, memory, swap and Disk usage.
But lag sources can be very numerous :
- swap usage if memory is too low
- CPU lagging
- Disk access conflict
- share of resources (for instance on Virtualized server)
- not enough threads
- bad configuration of PHP or Apache or MySql...