Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm making a website in Drupal, which allows users to add walkthroughs for games. However, those walkthroughs can contain over 500,000 words. Should I do this? Can both Drupal and MySQL handle that much of characters? If not, what can I use instead?

Thanks in advance.

share|improve this question
up vote 2 down vote accepted

Well, wouldn't you want something like an index node, that links to other nodes for each 'chapter' or level. I wouldn't worry as much about Drupal and MySql as much as the end user's browser.

Also, that is not really that much data. If a character is one byte which it often is, and say the average word is 4 characters, that is 4 bytes per word. So 4 bytes * 500,000 words is less then 2 MegaBytes. So from a computer's standpoint, that is not really huge.

share|improve this answer
Well, the browser can handle it, just like, which also has huge pages. I'll just make a dummy drupal on a local server and test it. Thanks anyway. If drupal crashes on the local server, I will simply use books like you suggested. – rightfold Jul 28 '09 at 18:20

Drupal and MySQL will be fine with that many characters.

You may want to install something like the Pagination module to make life easier on your users and their connections, though.

share|improve this answer

Why not create a simple drupal installation and post some Lorem Ipsum-nodes? Shouldn't take this long. Drupal uses LONGTEXT for node content so there shouldn't be a problem.

Bottleneck will be Mysql, I guess. PHPmyadmin can show you a lot of stats about your Mysql and give some advice about good or bad characteristics.

share|improve this answer

Also keep in mind that you'll see a 2 meg jump in memory usage every time that node is loaded or manipulated in some fashion.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.