Go Back   CodingForums.com > :: Server side development > MySQL

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 11-09-2012, 03:27 AM   PM User | #1
user.name
New Coder

 
Join Date: Aug 2007
Location: Philippines
Posts: 26
Thanks: 9
Thanked 0 Times in 0 Posts
user.name is an unknown quantity at this point
Overall site speed and performance - How will it be affected by a table..

I currently have a table in my mySQL database that continually receives data (accumulates up to 16k~ rows for less than 20hours)

Data is saved through ajax, on user mouse action.

The table is flat with 4 fields:
  • int(10
  • varchar(255)
  • text
  • date (timestamp)

I use php. How will this table affect overall site speed and performance? Thanks!

Last edited by user.name; 11-09-2012 at 03:38 AM..
user.name is offline   Reply With Quote
Old 11-09-2012, 05:18 AM   PM User | #2
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,168
Thanks: 59
Thanked 3,993 Times in 3,962 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
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.
Old Pedant is offline   Reply With Quote
Reply

Bookmarks

Tags
php, site performance, site speed

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 05:34 PM.


Advertisement
Log in to turn off these ads.