Monkuar Posted October 1, 2012 Share Posted October 1, 2012 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 Link to comment https://forums.phpfreaks.com/topic/268953-need-help-on-math/ 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. Link to comment https://forums.phpfreaks.com/topic/268953-need-help-on-math/#findComment-1381994 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 Link to comment https://forums.phpfreaks.com/topic/268953-need-help-on-math/#findComment-1382003 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.