Originally Posted by Old Pedant
Once again, I don't see why you would put posts for each forum in a separate table just for that forum. There is no DATABASE reason to do so. It will work just as well--and be easier to code--if there is only one table for all posts, no matter what forum.
Wouldn't it make getting results quicker, if the results were in a table with 10,000 entries, instead of 100,000?
It was all just an example, trying to mock a situation where changing the permissions during runtime might be desirable. I have since realized it was a fault in how I was thinking about it, and I agree with you that a connection shouldn't need to change permissions within a runtime. I'm not even to the point of considering the structure of forums database just yet, although I had always assumed smaller databases would equal quicker queries..