Speed...

Discussion in 'Support & Feedback' started by digitalpoint, Oct 27, 2009.

0
  1. #1
    Did some tuning on some nasty SQL queries that were running slower than what was ideal. Things should be much faster now (especially during peak times like right now).
     
    digitalpoint, Oct 27, 2009 IP
  2. dcristo

    dcristo Illustrious Member

    Messages:
    19,776
    Likes Received:
    1,200
    Best Answers:
    7
    Trophy Points:
    470
    Articles:
    7
    #2
    Thanks Shawn, I noticed it was acting a little sluggish over the last few days.
     
    dcristo, Oct 27, 2009 IP
  3. Bohra

    Bohra Prominent Member

    Messages:
    12,573
    Likes Received:
    537
    Best Answers:
    0
    Trophy Points:
    310
    #3
    really i can feel the speed thx for this change
     
    Bohra, Oct 27, 2009 IP
  4. Mobile-Monster

    Mobile-Monster Well-Known Member

    Messages:
    862
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    105
    #4
    Much better now, unlike yesterday where I encountered a lot of "connection reset" errors.
     
    Mobile-Monster, Oct 27, 2009 IP
  5. MhW

    MhW Active Member

    Messages:
    370
    Likes Received:
    23
    Best Answers:
    0
    Trophy Points:
    85
    #5
    Nice one Shawn :)

    Funny how making something just a second or two faster can have such a big difference. :)
     
    MhW, Oct 27, 2009 IP
  6. digitalpoint

    digitalpoint Overlord of no one Staff

    Messages:
    38,334
    Likes Received:
    2,613
    Best Answers:
    462
    Trophy Points:
    710
    Digital Goods:
    29
    #6
    Wasn't even a second or two. More like a SQL query that took 0.25 seconds to run was causing DB queries to get backed up when there's high traffic times. So the 0.25 second query was changed and is now 0.00002 seconds.
     
    digitalpoint, Oct 27, 2009 IP
  7. humm

    humm बहादुर बच्चा

    Messages:
    4,346
    Likes Received:
    850
    Best Answers:
    0
    Trophy Points:
    310
    #7
    Its better today, yesterday I did experience a lot of connection 'reset' & 'timed-out' problems. I find the search function also to have got faster.
     
    humm, Oct 27, 2009 IP
  8. rootbinbash

    rootbinbash Peon

    Messages:
    2,198
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    0
    #8
    It is a lot better today. Thanks Shawn
     
    rootbinbash, Oct 27, 2009 IP
  9. hello_welcome

    hello_welcome Well-Known Member

    Messages:
    1,632
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    155
    #9
    thanks Shawn today is the best :D
     
    hello_welcome, Oct 27, 2009 IP