Results 1 to 2 of 2
-
04-12-2011, 11:19 AM #1WHT Addict
- Join Date
- May 2008
- Posts
- 105
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?
-
04-12-2011, 12:23 PM #2Cloud Hosting Pioneer
- 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
-
10Mbit/sec vs. 100Mbit/sec
By Mac-Donald in forum Colocation, Data Centers, IP Space and NetworksReplies: 2Last Post: 04-06-2010, 12:43 AM -
$89 10 Mbit/sec Unmetered Servers, $5 per Mbit/sec Bandwidth - Steadfast Networks
By KarlZimmer in forum Dedicated Hosting OffersReplies: 0Last Post: 01-19-2009, 09:43 PM -
How to query rows who's ID's exist instead of any row
By Mark226 in forum Programming DiscussionReplies: 27Last Post: 01-16-2008, 12:03 AM -
Do not buy links from a normal word cloud site until you read this!
By KCgame in forum Other Offers & RequestsReplies: 0Last Post: 03-18-2007, 11:26 AM -
1xXeon 2.4 10Mb/sec $179.00 2x2.4 100Mb/sec $1499.00
By Linn_Boyd in forum Dedicated Hosting OffersReplies: 2Last Post: 04-21-2006, 06:57 PM