Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Number of articles or database size...
Mired in the quagmire of migrating from TextDrive to Joyent’s Shared Accelerator server, I’ve discovered that my weblog database is approximately 26MB in size. One tool for working with that database (phpMyAdmin) shows a limit of 32MB for a database.
With around 5000 articles/posts in my weblog, I’m curious about any limitations I’m going to run up against with MySQL or Textpattern. Will these products allow me to go from 5000 to 20000 posts? If not, what’s the right solution? Thanks.
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
Re: Number of articles or database size...
I have another question re a similar matter.
I understand that txp has no limitation regarding the size of the db but what happens if one wants to migrate a db which is larger to the max size which is allowed for importing
I am not talking about the space in the db allocated by the server to the user but the size limitation during the import.
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Number of articles or database size...
If you have shell access, you can use command line MySQL tools which shouldn’t have any limits other than those of the database itself.
For TXP, having 5000 or 50000 posts doesn’t matter much. MySQL takes care of the heavy lifting and has been used with far more records than that. The only place where I think speed decreases as fast as the size increases is the full text search, but that can be remedied with some code changes (using match instead of rlike).
Offline
Re: Number of articles or database size...
Thanks. That’s a big help.
Unix/Solaris command line stuff (SSH, rsync, cygwin, etc.) isn’t an area of expertise for me, but it’s clear that’s going to have to become a part of my hosting relationship. I’m glad to know that the basics of MySQL and Textpattern are sound platforms for future writing.
“Well, I, uh, don’t think it’s quite fair to condemn a whole program because of a single slip-up, sir.” General ‘Buck’ Turgidson
Offline
Pages: 1