Performance lags

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 !