Re: [PHP] Limit query/function time

2009-10-22 Thread Philip Thompson
On Oct 22, 2009, at 3:30 PM, Phpster wrote: Have you run an explain plan on the query? Bastien Sent from my iPod Yes, I have. For giggles, I wanted to run it again. Here it is (slightly stripped down) and it looks good to me. mysql> EXPLAIN SELECT -> `p`.`patient_id`, -> `p`.`add

Re: [PHP] Limit query/function time

2009-10-22 Thread Philip Thompson
On Oct 22, 2009, at 3:26 PM, Eddie Drapkin wrote: On Thu, Oct 22, 2009 at 4:14 PM, Philip Thompson > wrote: Hi all. I'm running into a random issue where sometimes it take several minutes (up to 10 or 15) to complete a query. According to 1 or 2 references, this may be a mysql bug. These li

Re: [PHP] Limit query/function time

2009-10-22 Thread Phpster
Have you run an explain plan on the query? Bastien Sent from my iPod On Oct 22, 2009, at 4:14 PM, Philip Thompson wrote: Hi all. I'm running into a random issue where sometimes it take several minutes (up to 10 or 15) to complete a query. According to 1 or 2 references, this may be a

Re: [PHP] Limit query/function time

2009-10-22 Thread Eddie Drapkin
On Thu, Oct 22, 2009 at 4:14 PM, Philip Thompson wrote: > Hi all. > > I'm running into a random issue where sometimes it take several minutes (up > to 10 or 15) to complete a query. According to 1 or 2 references, this may > be a mysql bug. These links explain the similar problem I'm experiencing: