-Original Message-
From: Steven Ducat [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 11, 2004 5:32 PM
To: [EMAIL PROTECTED]
Subject: How can I avoid filesort with BETWEEN and ORDER BY
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading and research
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading and research I still can not get the hang of
this. Details are as follows:
2 Tables
CREATE TABLE `p_ad` (
`id` int(11) NOT NULL auto_increment,
`cat` mediumint(9) NOT NULL default '0',
`title`
.
Donny
-Original Message-
From: Steven Ducat [mailto:[EMAIL PROTECTED]
Sent: Sunday, April 11, 2004 5:32 PM
To: [EMAIL PROTECTED]
Subject: How can I avoid filesort with BETWEEN and ORDER BY
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading
I am trying to optimize a query using both BETWEEN and ORDER BY but
after months of reading and research I still can not get the hang of
this. Details are as follows:
2 Tables
CREATE TABLE `p_ad` (
`id` int(11) NOT NULL auto_increment,
`cat` mediumint(9) NOT NULL default '0',
`title`