Slow forum access, @Milo (Technics)
My forum has currently more than 200,000 entries. It sill runs nicely, but I noticed that the performance is slowly degrading. After contact with my web host he replied by saying that there are a lot of database queries.
Yes, there a several queries on every request for a page. Some of them are optimisable.
Is there is for instance a possibility to calculate the total number of entries only once a day, and keep a daily counter for the new entries after the last calculation?
It would be possible to count the entries once a day and set a second counter for the entries of the day so both values could be totalled. But that's not the way I would do it. For me it seeems to be more feasible to reset the one value for the number of entries every time a new entry occurs. So we'll have no counting at all, only a number in a table, that increases from time to time.
@Milo: Since we have the new table
*_temp_infos I think, it would be a good idea to store such values (one valid value for a whole forum but not a static value) there, wouldn't it?
Or perhaps there are other ways to speed up the database?
I would expect several queries as optimisable.
further development of mlf1
- Slow forum access / database too large -
- Slow forum access / database too large - Otto Tuil, 2017-03-18, 13:29
- Slow forum access, @Milo -
- Slow forum access, @Milo - Milo, 2017-03-19, 12:31
- Slow forum access, a few thoughts for a discussion - Auge, 2017-03-19, 21:13