Post table is too big, how to reduce or split it?

[raywjohnson]

Originally Posted by Marco van Herwaarden

That would also need a second license.

I forgot to mention that this might be the case.

--RayJ

[raywjohnson]

After some thought on the fact that you would need two licenses to create an archive in the way I suggest (even though you would be using only one site, for one forum, accessing the same data), I think the solution is to use phpBB3 (or other free forum software) as the archive install.

--RayJ

[forsanelhaq]

i have the same problem and always my table post crashing

please help me something like product because i am not expert in sql

[Paul M]

Tables should not "always" crash, no matter what size they are. If this is your problem then the issue is not its size, but your mysql and server itself.

[Alfa1]

Would it be possible to work with multiple databases and make all databases searchable with Sphinx?

[kmike]

Yes, you can define multiple data sources, one for each database, and combine corresponding indexes using a single distributed index. There's one important limitation though - document ids should be unique throughout all databases.

[HeLLCiTo]

up,

show up any solution to this?

[Magnumutz]

The post table size is a problem for pretty much ALL big boards, because there are lots of posts and when performing database back-ups or restores, you might get timeouts because of the hugeness of the post table.
A solution would be awesome!

[SteveC]

Has there ever been any solution found to this? What do you do when a vbulletin site gets large?

[raywjohnson]

My solution was to setup a second forum software, then convert and archive all posts over two years old to that system. It makes the old post table read only and keeps the live post table at a manageable size.

--RayJ