1
Some pages on my site do around 100 queries.
Most of this queries are equal and return the same result.
Many of them are simple things like getting the username or groups permissions.
I have made a test hack in mysqldatabase.php to cache all sql results and only make queries that are unique.
This have reduced queries from 100 to 65.
I know that this can have negative impacts as results can become incacurate, for example
querie users online -> 10
update user online -> now become 11
querie users online -> 10(because it returns the result of the first querie)
This example is not important. I was wondering if you can find me a example where this hack could become inconvenient.
If you cannot find one, then we should think in adding this as an core option.