Monkuar Posted October 1, 2012 Share Posted October 1, 2012 (edited) Okay my posts table on my forum has 12,000 rows filled with users posts content with a structure of 11 columns mostly using tinyints and 1 field "mediumtext" for the users post. so with 12,000 rows filled, that's roughly 12,000 posts it shows 2.5 megaBYTES. now I need to do the math on how many posts can I hold with 5 GIGABytes of space (SSD Cheetah) /etc? Thanks, We need to also assume each users "post" is not full of data, and normal, so I know it's not perfect but a rough estimate please? Please help Edited October 1, 2012 by Monkuar Quote Link to comment Share on other sites More sharing options...
Zane Posted October 1, 2012 Share Posted October 1, 2012 5 GB is 5120 MB, so with that part out of the way, Multiply 5120 by 12000, then divide by 2.5 (5120 * 12000) / 2.5 = 24,576,000 rows. Quote Link to comment Share on other sites More sharing options...
Monkuar Posted October 1, 2012 Author Share Posted October 1, 2012 Great, appreciate this Zane. I guess a 5GB SSD Server will be just fine for now, 24 Million posts ( roughly ) will take a while to achieve. Topic Solved Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.