Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2012
    Posts
    2

    Unanswered: database query statistics

    hi,
    I am looking for studies about statistics on database usage. These are the questions I am looking the answer for:

    1. What is the average amount of tables in an typical database?
    2. What is the average size of a record in a table?
    3. What is the typical frequency of INSERTs, SELECTs, UPDATEs and DELETEs ?
    4. What is the most used WHERE condition for SELECTs?


    I know it depends on the application, but there must be some statistics. Like the number of car accidents every country reports, it will be different for every country, but the statistics exist. For databases I can't find anything.
    Last edited by nulik; 02-13-12 at 09:48.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >I know it depends on the application, but there must be some statistics.
    I disagree

    What do you plan on doing with these numbers once you have them?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Feb 2012
    Posts
    2
    Quote Originally Posted by anacedent View Post
    >I know it depends on the application, but there must be some statistics.
    I disagree

    What do you plan on doing with these numbers once you have them?
    it is for a database engine I am developing. I need these statistics to know how to optimize my code. For example I am now optimizing for READs, instead of UPDATEs, so I would like to know how big is the universe of the applications I would be covering with my engine

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    for some/many OLTP applications SELECT activity is about 10 times greater than DML activity
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

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