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

Reply via email to