Re: performance on query with ORDER BY clause

2005-02-03 Thread Marc Dumontier
ishall http://www.friendster.com -Original Message- From: Marc Dumontier [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 02, 2005 12:02 PM To: mysql@lists.mysql.com Subject: performance on query with ORDER BY clause Hi, I have a simple query with an ORDER BY clause, and it's taking forever

RE: performance on query with ORDER BY clause

2005-02-02 Thread Dathan Pattishall
ishall http://www.friendster.com > -Original Message- > From: Marc Dumontier [mailto:[EMAIL PROTECTED] > Sent: Wednesday, February 02, 2005 12:02 PM > To: mysql@lists.mysql.com > Subject: performance on query with ORDER BY clause > > Hi, > > I have a simp

performance on query with ORDER BY clause

2005-02-02 Thread Marc Dumontier
Hi, I have a simple query with an ORDER BY clause, and it's taking forever to run on this table. I hope i've included all relevent information...it might just be one of the4 server variables which need adjustment. the query is SELECT SubmitId from BINDSubmit ORDER BY SubmitId SubmitId is the pri