Results 1 to 2 of 2
  1. #1

    Is it normal to get 2 sec query that returns 0 row in cloud server?

    This is something i saw quite often in my mysql slow query.

    # Query_time: 2 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
    SELECT manager_id
    FROM teams
    WHERE league_id='1'
    AND is_playable='Y';

    I did the same query above in my PC and it took me 0.750 sec.

    It is normal in cloud server to get 2 sec query on something that returns 0 row and examined 0 rows?

  2. #2
    Join Date
    Jan 2010
    Posts
    1,030
    No, it's not normal.

    BTW you don't need to open a new thread with every question, you could keep your current thread regarding the same issue.

Similar Threads

  1. 10Mbit/sec vs. 100Mbit/sec
    By Mac-Donald in forum Colocation, Data Centers, IP Space and Networks
    Replies: 2
    Last Post: 04-06-2010, 12:43 AM
  2. Replies: 0
    Last Post: 01-19-2009, 09:43 PM
  3. How to query rows who's ID's exist instead of any row
    By Mark226 in forum Programming Discussion
    Replies: 27
    Last Post: 01-16-2008, 12:03 AM
  4. Do not buy links from a normal word cloud site until you read this!
    By KCgame in forum Other Offers & Requests
    Replies: 0
    Last Post: 03-18-2007, 11:26 AM
  5. 1xXeon 2.4 10Mb/sec $179.00 2x2.4 100Mb/sec $1499.00
    By Linn_Boyd in forum Dedicated Hosting Offers
    Replies: 2
    Last Post: 04-21-2006, 06:57 PM

Posting Permissions

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