Hi, I got stuck on query....about a million rows in one table...it slows up my server...
How can I improve my server on managing a request like this? I manually loop the monthly data query...I got a database that is full of data daily...so all I need to get the maximum of every month is to query by loop than to use the SELECT MAX() FROM FOO...is there any way to improve a GROUP BY query..i know it can be done in group by...I done it before... Anybody done this before....i need your help R.B.Roa Traffic Management Engineer PhilCom Corporation Tel.No. (088) 858-1028 Mobile No. (0919) 30856267 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php