From: Eric Savage
Date: April 26 1999 7:21pm
Subject: ORDER BY Optimization
List-Archive: http://lists.mysql.com/mysql/2411
Message-Id: <199904261921.PAA31857@mail.hotpop.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit

I have a table that is the data source of a nested tree structure, and I
intended to use this:

UserID INTEGER,
FolderID INTEGER,
FolderName VARCHAR[64] or maybe CHAR[64],
MasterID INTEGER,

My question is this, how much will an ORDER BY FolderName slow this down
by?  This query will be run many many thousands of times a day, and I
would like to know if it would be better to sort it in the cgi, or in SQL
(which would obviously be alot easier). I am just looking for a ball park
increase like 10% 100% etc.

Thanks

Eric Savage
esavage@stripped