Welcome Guest, Not a member yet? Register   Sign In
Pagination Algorithms
#11

[eluser]kurucu[/eluser]
I understand your message_content table now, that's a nice way to tackle the problems.

I'll have to do a few calculations and see just how bad an n:1 content:post setup might get. I don't think it would be too bad, but now that you've made your suggestion about a message_changes table, I am reconsidering! I hope you don't mind Smile I think that could be a tidier way to keep a history without clogging up the posts table and slowing down the necessary queries with subqueries or requeries in PHP.

In fact, it shares similar rationale to my user post count setup!

While I like to keep my data clean and logical (I'm not familiar with the vernacular, as I changed profession a while ago, and this is rather a hobby) I think keeping a post count in the user table is not terrible, as it is a property of theirs.

I see no reason not to share the code, now that you mention it. Once it's working at a reasonable level and a bit more secure I'll share it somewhere and post a link.




Theme © iAndrew 2016 - Forum software by © MyBB