mysql mysql wrote:
Thanks for the response Chris, although I can't seem to reproduce the
problem now, but I'm sure you're right.
There's something else strange that I've encountered while trying to
optimize this query. I've got two machines, dev and production. After
adding the index to the
On 1/24/08, Chris [EMAIL PROTECTED] wrote:
mysql mysql wrote:
Thanks for the response Chris, although I can't seem to reproduce the
problem now, but I'm sure you're right.
There's something else strange that I've encountered while trying to
optimize this query. I've got two machines,
mysql mysql schrieb:
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4)
Thanks for the response Chris, although I can't seem to reproduce the
problem now, but I'm sure you're right.
There's something else strange that I've encountered while trying to
optimize this query. I've got two machines, dev and production. After
adding the index to the title attribute on the
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4) drop index
5) execute same
mysql mysql wrote:
Can anyone explain the following? I encountered the following very strange
behaviour while attempting to optimize a query (more details are provided
later on for those interested):
1) execute query
takes 2 minutes
2) add index
3) execute same query
takes 11 seconds
4) drop