MySQL Forums
Forum List  »  Newbie

Re: max function
Posted by: paul ernest
Date: October 07, 2009 06:25AM

Thanks for all of your help.

I do like to see the additional ways of doing things, it helps me learn how the system works, and gives me another resource to try first before I bother the nice people on this forum with my problems.

I've changed my code slightly, and now just need the largest value in the column, and no longer need to know the values associated with it, so I've been using the MAX function. Unfortunately it does seem rather slow, 1.5 seconds for a query on a 200,000 entries in a myISAM table.

Once again thanks

Paul

Options: ReplyQuote


Subject
Written By
Posted
October 05, 2009 11:49AM
October 05, 2009 11:49AM
October 05, 2009 12:01PM
October 05, 2009 12:01PM
October 05, 2009 12:08PM
October 05, 2009 12:12PM
October 06, 2009 08:57PM
October 07, 2009 04:09AM
October 07, 2009 05:06AM
October 07, 2009 05:48AM
Re: max function
October 07, 2009 06:25AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.