Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New Coder
    Join Date
    Aug 2007
    Location
    Philippines
    Posts
    26
    Thanks
    9
    Thanked 0 Times in 0 Posts

    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 04:38 AM.

  • #2
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    27,117
    Thanks
    80
    Thanked 4,554 Times in 4,518 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.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •