I like what I see in SMF and considering it for my site. There is one last issue, if the database gets too big what options do I have?
I have done a little search on google about mySQL database limitation and it seems that the file size is max out at 4 gig. I plan on using the forums as a knowledge base system, therefore it's imperative that I can accumulate the topics/posts over many years and be able to search the topics/posts all the way to the beginning.
Is this 4 gig limitation true? If so it will apply to all forum software out there, right? I guess the SMF software can be written to span databases once it gets to a certain size? I know most people will not need this capability, but I do and if it costs a reasonable fee I am willing to pay for it.
Any idea?
Well this is really a good issue :o But filling up 4 gig is really a rear case. Well the alternative option for this can be making the old posts moved to archive section.
keep in mind as well that the next major revision of smf will feature database abstraction, meaning support for postgresql as well as mysql. im not sure of the exact limitations right off hand
Filling up a couple of gb would probably take a few million posts.
So if your just starting your site, you shouldn't really need to worry about it for a long time.
Lainaus käyttäjältä: karlbenson - joulukuu 26, 2007, 07:35:29 AP
Filling up a couple of gb would probably take a few million posts.
So if your just starting your site, you shouldn't really need to worry about it for a long time.
Incidentally, I was speaking to The Illuminati (http://www.simplemachines.org/community/index.php?action=profile;u=6) about his database awhile ago and he is almost at 1million posts and isn't anywhere near 1GB for the whole database let along one table.
Also this (http://jeremy.zawodny.com/blog/archives/000796.html) page implies that the limit is much larger when moving to x64.
Thanks for all the replies,
I realize it will take a while to reach the 4 gig limitation but it's better to plan ahead :) I guess the database can be stopped at 4 gig then a new database will be started. I guess a script can be written to search across all available databases? Stopping the database at 4 gig makes a lot of sense because it will fit onto a DVD-R very nicely :)
I plan on installing SMF the next few days and play with it for awhile, will see what happens.
The 4 gig limitation is per-table (as each table is stored in its own file). Also, it only applies to MyISAM tables due to the way the index file works. InnoDB tables are not affected.
More information is at http://jeremy.zawodny.com/blog/archives/000796.html