Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
add comment

4 Answers

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 gamefaqs.com, 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
add comment

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
add comment

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
add comment

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
add comment

Your Answer

 
discard

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.