Run Time Question

Discussion in 'MySQL' started by phaze3131, Oct 9, 2009.

  1. #1
    Hey guys my question pertains to Runtime on a sorted list in a mysql database that displays its value on a webpage.

    so lets say my sorted list is a range of numbers from 1-100,000 and it is populated with say X values all sorted.

    How could I find out my runtime to find out if a value is in the list already or not.

    Will that runtime translate directly to the user on the website? I'd assume there would be some static linear delay due to passing the value to and from the database to say the actual webpage that's in say PHP.


    Thank you so much huge help!
     
    phaze3131, Oct 9, 2009 IP
  2. phaze3131

    phaze3131 Well-Known Member

    Messages:
    538
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    140
    #2
    maybe does someone know where I could go to find out something like this?
     
    phaze3131, Oct 11, 2009 IP
  3. phones2me

    phones2me Peon

    Messages:
    35
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    do you mean 'execution time'?
     
    phones2me, Oct 15, 2009 IP
  4. alexpr07

    alexpr07 Active Member

    Messages:
    284
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    73
    #4
    I didn't get your question. Were you asking how long it would take to check whether a record exists in a table?
    If you have an indexed table with 100K records (rows), it would take less than 1 second to check whether a record with your value exists. Could be much faster than 1 second, you just won't see much difference between .3 and .05 second
     
    alexpr07, Oct 15, 2009 IP