Re: [Mantisbt-dev] Database Indices

[Kenzaburo I. <ke...@30...>]

I finished some cursory timing. Here are some results from my testing:

OLD is without indices, NEW is with.  I've addeda about 25 or so throught the
various tables.

All times in seconds.
600Mhz P3, 512MB (128MB used), Win2K
------------- OLD  -- NEW --- DIFF
News Page     0.407   0.401  -0.006 (-1.4%)
View All      3.487   2.417  -1.070 (-44% )
View Bug      0.322   0.318  -0.004 (-1.2%)
Summary       1.405   1.348  -0.057 (-4.2%)
Manage Users  2.870   2.890  +0.020 (+0.7%)

First off, this is more eyeballing things than being scientific.  I took about
20-30 samples of each page and took what looked like the mean (the number that
came up most often).

I'm going to investigate the Manage Users page more carefully as it didn't
exhibit any improvement.  People storing BLOBS in the database will see a
large improvement in View Bug times.

I'm also investigating the Summary pages further.

Thanks,
-Ken