Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted April 2, 20168 yr Hi, We recently upgraded to 4.1.9 and having some performance issues. If anyone can help me out to resolve these issues that will be great. 1) Page load issues. Pages are loading very slow compared to previous version. Out post table size is 5GB and 90% of the posts belong to 1 perticular forum. Other forums are loading fine but the forum with highest number of posts is very slow. Also if i archive the posts will it increase the performance? Will the archived posts show in search results? Please let me know.
April 3, 20168 yr Ok, so.. a lot of posts. When you log into the ACP do you still see background processes running? You'd see them right on top of the dashboard. If there is nothing there but the usual stuff then you have no background processes running and we/others can move on to the next step.
April 3, 20168 yr Author All the background processes are completed. Also can you please let me know changing the storage to Mysql will help?
April 3, 20168 yr Won't help. Need the following: Server: Is it dedicated, vps, or shared hosting? How much memory? Also Mysql version and PHP version.
April 3, 20168 yr Heading to bed now. If you can pull your my.cnf and php.ini files and attach them here that would help (me and others who put their eyes on this) Might later need to pull some mysql error logs, some other stuff to see if you are getting table/row locks, indexes not working all that well, etc.not sure if that bridge has been crossed with the 4-series yet.
April 6, 20168 yr Author We moved to new dedicated server and things are lot better now. New server has Mysql 5.6 and php5.6 ... Generally with such huge databases what will be the best practices? and also to increase performance do i need to disable any features in our forums? any kind of information will help us. Also if you know where i can find any freelancers that are experienced in IPB forums please let me know.
April 6, 20168 yr It looks like that you got a dedicated server and do a basic installation of mysql and php so it is normal to not have very good performance..... Installing software without optimizing will never help alone.... You will need system adjustments and optimization of your installed software.
April 6, 20168 yr Management If you can archive off some older posts, that will really help. If you have years worth, it's probably worth archiving off topics that haven't had a reply in > 18 months. These topics are still readable but you cannot reply and they do not show in search. Check out our guide for more help:
April 6, 20168 yr Archiving will help performance but in my opinion in most cases is not good for the forums as it is limiting functionality for members And let's say that you do it now then after a few months you will have the same problem I think it is better to look for a scaling solution than hiding temporary the problem....
Archived
This topic is now archived and is closed to further replies.