RE: Slow performance Query

2009-08-11 Thread Gavin Towey
ssage- From: 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 shoul

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 r

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 checked