Re: Workaround for ORDER BY DESC

be used. To apply other where clauses, etc, each row must be examined. Hope this helps, its long and off the cuff, and if its wrong, please come shoot me. regards, sean peters [EMAIL PROTECTED] On Friday 16 April 2004 13:51, Steven Ducat wrote: I have 2 tables and 1 query. The problem is when

Workaround for ORDER BY DESC

I have 2 tables and 1 query. The problem is when I implement ORDER BY p.date DESC it hits the wall. I understand that MySQL is not the best at ORDER BY DESC so I am after some tips on possible workarounds to avoid using ORDER BY DESC. The site will list classifieds ads so I need to display them fro

Workaround for ORDER BY DESC

I have 2 tables and 1 query. The problem is when I implement ORDER BY p.date DESC it hits the wall. I understand that MySQL is not the best at ORDER BY DESC so I am after some tips on possible workarounds to avoid using ORDER BY DESC. The site will list classifieds ads so I need to display them

Re: How can I avoid filesort with BETWEEN and ORDER BY

ave 0 slow queries. 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 month

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 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` varchar(50

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 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` varchar

SELECT 9 BETWEEN 1 AND 0

I am trying to create a select query to find the post town of a users post code. I am using Royal Mails (UK) post town gazetteer. UK Postcode (eg. RH6 9XJ). The first column contains the first half of the post code (eg. RH6) and the next column holds the range of the second half (eg. 2AA-6PP). I