PDA

View Full Version : VB_Postparsed question


Amenadiel
09-28-2008, 01:14 AM
How does VB engine handle the table vb_postparsed?

I'd like to experiment with Mysql 5.1 partitioning features, but I need to know if the table is checked on a per post basis or is it queried for the whole thread with a join.

Marco van Herwaarden
09-28-2008, 09:57 AM
Either.

But i don't think you want to partion this table. If it gets too large lower the number of days posts stay in cache in your vBulletin Options.

Amenadiel
09-28-2008, 02:36 PM
I'm not concerned about size, it's just that partitioning would allow concurrent insertions and most likely a faster throughput.

I thought I could move it to memory engine, but that one doesn't support text columns.