Profile My Little Forum - some suggestions (General)
Hi,
So it is more important that the forum is fast to read than it is fast to post.
Yes, your are right. The indexing-process will decelerate the INSERT/UPDATE/DELETE statements but, I believe, it is a quite good compromise.
By adding this index alone, together with the two indexes above which I have added previously, the query in includes/index.inc.php at line 187 went from 1 000 milliseconds to 22 milliseconds! A very huge improvement!
Wow that's more than I expected. Fine.
----------
After these new indexes, the status for me is as follows:
includes/index.inc.php, line 69: about 600 milliseconds
includes/main.inc.php, line 339: about 600 milliseconds
includes/main.inc.php, line 336: about 120 milliseconds
includes/index.inc.php, line 187: about 22 milliseconds
(this was the query that before took over 1 000 milliseconds)
We will take a closer look to this queries and give some suggestions for indexing.
regards
Micha
--
applied-geodesy.org - OpenSource Least-Squares Adjustment Software for Geodetic Sciences