I am working on a team of people wanting to build our own fiction site and the question that our web guy wants to know is what kind of strain can the site take, how many stories for example can it hold before issues, how many users, etc.
Can someone give me any info on the theoretical limitations of the software? What's the scale limit I guess is the question.
thanks.
AgentExeider
Well, the theoretical limit is basically how many story IDs and user IDs the SQL server can handle, being 2^64 unsigned. Since we can safely assume the largest headcount will either be chapters or reviews, depending on how lazy the readers are, this will be your theoretical anchor.
Thousand reviews per chapter and thousand chapters per story would make that about 18446744 million stories - assuming you could store that amount of data.
That's just MySQL numeric field size restraints.
I have no idea how huge the largest archive around is, honestly.
Maybe some members here can post numers of the largest eFiction 3 run archives they have seen.
That does help, what I'm trying to figure out is how stable it is when you have a vast number of users connecting and going around the site at once. I mean like sites like FF.net or AO3 get like thousands of users an hour doing all sorts of thing. I was trying to find out how robust efiction is and how much load it can take.
So any users who can post stats on the largest sites you've seen would help, thank you.
