Slow performance Query

2009-08-11 Thread Tachu®
Hi guys I've been having some slow performance on queries that should otherwise be pretty fast. I've checked my indexes etc. and cant see what could cause it here is an example. This one is taking long in the sending data step. although its running on localhost so its not like its a network

Re: Slow performance Query

2009-08-11 Thread mos
It is slow probably because you are using where user_id='1421767810' and user_id is an integer. I think this is one of those d'uh moments. :-) Mike At 01:18 PM 8/11/2009, Tachu® wrote: Hi guys I've been having some slow performance on queries that should otherwise be pretty fast. I've

Re: Slow performance Query

2009-08-11 Thread Dan Nelson
In the last episode (Aug 11), Tachu(R) said: Hi guys I've been having some slow performance on queries that should otherwise be pretty fast. I've checked my indexes etc. and cant see what could cause it here is an example. This one is taking long in the sending data step. although its

RE: Slow performance Query

2009-08-11 Thread Gavin Towey
: Dan Nelson [mailto:dnel...@allantgroup.com] Sent: Tuesday, August 11, 2009 1:09 PM To: Tachu(R) Cc: mysql@lists.mysql.com Subject: Re: Slow performance Query In the last episode (Aug 11), Tachu(R) said: Hi guys I've been having some slow performance on queries that should otherwise be pretty fast