Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt November 11, 2024
Axel Wers Posted March 25, 2011 Posted March 25, 2011 Is there in future any solution with posts table? This table is growing very fast and in my case it's size is 2/3 from whole database (230 tables). Very big posts table can make problems with optimization. Maybe would be good when posts were divided to more posts tables.
Robulosity2 Posted March 25, 2011 Posted March 25, 2011 Is there in future any solution with posts table? This table is growing very fast and in my case it's size is 2/3 from whole database (230 tables). Very big posts table can make problems with optimization. Maybe would be good when posts were divided to more posts tables. Ok but how many rows and volume of data in it? I think think MySQL's limit is 2.1GB for a single Table and if you have that many posts, Please lord prune em =p MySQL Doesn't really have an issue when it executes via Console doing the optimization it just takes longer, it would probably fail miserably via phpmyadmin or ACP how ever beyond that there are ways to split the table and just use a form of symbolic links (I haven't had to do it for ages and talking about the steps in this forum isnt really the place) but I think IPS support could do it with out much issue
bfarber Posted March 25, 2011 Posted March 25, 2011 Actually, MySQL generally runs into problems at 4GB tables (we've had customers hit this), but it's easy enough to resolve with a few queries so long as the OS can handle files this size. That said, we've got ideas for the post table in the future, yes. We are going to implement some of the core underpinnings that we'll need in place in 3.2, but the features I'm referring to won't be coming in the next release just yet. They require some more planning and thought first.
Axel Wers Posted March 25, 2011 Author Posted March 25, 2011 the optimization it just takes longer Yes, it's problem for me. Whole database I can optimise 10x faster than one posts table. That said, we've got ideas for the post table in the future, yes. We are going to implement some of the core underpinnings that we'll need in place in 3.2, but the features I'm referring to won't be coming in the next release just yet. They require some more planning and thought first. Thanks. In this time it's not problem for me, but in future will be. But when you have some plans with this, then it's good.
THL Posted November 14, 2011 Posted November 14, 2011 My posts table is over 2GB, would be good to see any improvements to help when optimizing and upgrading big boards..
Recommended Posts
Archived
This topic is now archived and is closed to further replies.