Results 1 to 6 of 6
Oct 12, 2012, 13:48 #1
- Join Date
- Oct 2011
- 0 Post(s)
- 0 Thread(s)
Why is this query taking forever to run??
I have a table with a few 100K records. I have an index on column PiNumber - but when I run the following query in phpmyadmin it will run for
30+ minutes ...
But ... when I just do this simple query it runs in under a second
When i run show processlist, the query is stuck in state 'Sending data'