Hi folks, sorry, I was quoting someone from a while ago...
So I'm not really sure myself! - [webmasterworld.com
I was worried I was being a bit query heavy in my code, but I guess the only way to really know these things is to properly test it with a bunch of people!...(any effective test methods that don't involve finding a ton of people to all pressure your site a once would be handy? :)
I'm writing a kind of forum type system (with an sql database behind it) and think that some people will be writing a lot of text in it. I've tried various database structures since I started, I had one table for the post text, and another for keeping track of which post follows which post and so on, but then have opted to put it all in one table.
My worry was that with all the numbers I'm using to keep track of which 'conversation' is which and who is replying to what and where, and in what order it all needs to be reproduced, post dates etc the table now has 20 or so columns, including a large chunk of text and a few different dates
As I was adding more columns recently I remembered that previous post and something about 'pages' so thought I'd ask.
Having googled it a bit I find reference to sql 'pages' being 8kb, but beyond that I guess I've some serious reading to do if I want to get my head round it all.
Thanks for the links and pointers :)
I've spent most of my time learning the php involved so far and just hoping my guesses on database structure are good enough!