[Dbix-class] Encapsulate multiple steps for insertion
Tobias
list at funkreich.de
Fri Jan 12 09:07:50 GMT 2007
> You might consider whether splitting this table was a premature
> optimization. I can't know if it is, it's really up to you, but it's
> often the case (especially with forum posts, as the most typical
> pattern will be to insert the data once and then read-only from there
> out, with only a small fraction of the texts being updated by later
> edits, and even then very few times).
To be honest I'm dealing with a legacy database schema which is currently
serving approximately 30 million page impressions/month and 12.000 posts/day
and I don't want to change it because it performs really well. I took a look
into other successful high-volume forum applications like vbulletin and phpbb
and they all spin off the message texts from the post entries. I suppose they
know what they're doing ...
--Tobias
More information about the Dbix-class
mailing list