CodingForums.com - View Single Post - Overall site speed and performance

Old Pedant · 11-09-2012, 05:18 AM

Too broad a question.

What indexes are there on the table? What kinds of queries will you be using? What fields will be used in your WHERE clauses and/or JOINs?

Will you ever "prune" this table? (Remove old records, that is.)

TEXT fields are, in general, the killer in DB performance. How large, on average will your TEXT contents be?

Or maybe a better question: How much disk space are you adding to the DB per day?

11-09-2012, 05:18 AM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,168 Thanks: 59 Thanked 3,993 Times in 3,962 Posts	Too broad a question. What indexes are there on the table? What kinds of queries will you be using? What fields will be used in your WHERE clauses and/or JOINs? Will you ever "prune" this table? (Remove old records, that is.) TEXT fields are, in general, the killer in DB performance. How large, on average will your TEXT contents be? Or maybe a better question: How much disk space are you adding to the DB per day? __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.