Well, after a fatal db-crash a few weeks ago ppl on a forum I admin on have been thinking of splitting the topis into one(or more) table, we could call them prefix_posts_old and prefix_topics_old. Someone also mentioned that they migfht should be searchable.
Someone that done anything like this and should it really be necessary? Not even 500 000 posts on the forum I mean.
Peetra.
Splitting posts/topics to an extra db-table
Forum rules
Please post any phpBB 3.1.x related topics in the forum.
Please post any phpBB 3.1.x related topics in the forum.
- RMcGirr83
- Past Contributor
- Posts: 6243
- Joined: 30 Nov 2006, 14:23
- Real name: Rich McGirr [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
Re: Splitting posts/topics to an extra db-table
For what purpose...I mean why do that?
- tumba25
- Past Contributor
- Posts: 1058
- Joined: 24 Oct 2007, 13:10
- Real name: Jari Kanerva
- Location: Kokkola, Finland.
- Contact:
Re: Splitting posts/topics to an extra db-table
Totally unnecessary. I assume that you would still want them to be accessible through the forum. I'm trying hard to find any gain with doing that, but with no success. Depending on what file system you have, you can have a table size of at least 2TB and that is a lot more than 500k posts.
- tumba25
- Past Contributor
- Posts: 1058
- Joined: 24 Oct 2007, 13:10
- Real name: Jari Kanerva
- Location: Kokkola, Finland.
- Contact:
Re: Splitting posts/topics to an extra db-table
I'm sure the table crash or not being able to fix it has nothing to do with the table size.
You would need to do some heavy modifying to get that to work well with your forum. The disadvantages would probably be much greater than the advantages.
I think you seem to try to fix the wrong error, you should probably look at PEBKAC.
You would need to do some heavy modifying to get that to work well with your forum. The disadvantages would probably be much greater than the advantages.
I think you seem to try to fix the wrong error, you should probably look at PEBKAC.
- Peetra
- Supporter
- Posts: 26
- Joined: 29 Sep 2010, 04:12
- [phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
Re: Splitting posts/topics to an extra db-table
I am just the messenger here but I am sure the community slaps tumba25 for PEBKAC.
Return to “phpBB 3.0.x "Olympus" discussion”
Who is online
Users browsing this forum: No registered users and 30 guests