Hi, I still got stuck on a query...so slow...it took a minute or more
How can I improve my server... Specs... Computer: Pentium II 333MHZ 128MB 20GB HardDrive OS: Windows 98, Database: Table definition | edate | date | YES | | NULL | | etime | int(5) unsigned zerofill | YES | | NULL | | lec | varchar(5) | YES | | NULL | | trunk | varchar(5) | YES | | NULL | | bound | varchar(5) | YES | | NULL | | att | int(10) unsigned zerofill | YES | | NULL | | suc | int(10) unsigned zerofill | YES | | NULL | | ovf | int(10) unsigned zerofill | YES | | NULL | | fir | int(10) unsigned zerofill | YES | | NULL | | alt | int(10) unsigned zerofill | YES | | NULL | | ter | int(10) unsigned zerofill | YES | | NULL | | rng | int(10) unsigned zerofill | YES | | NULL | | tot | float unsigned zerofill | YES | | NULL | | cal | float unsigned zerofill | YES | | NULL | | mtu | float unsigned zerofill | YES | | NULL | | eqp | int(10) unsigned zerofill | YES | | NULL | | srv | int(10) unsigned zerofill | YES | | NULL | | loc | int(10) unsigned zerofill | YES | | NULL | | flt | int(10) unsigned zerofill | YES | | NULL | Indexing.... Edate Etime Lec Trunk Bound Att Suc Cal Eqp Currently my table is filled with 1M+ rows... My problem is...when I used MAX() and GROUP BY enclosed in SELECT statement, the performance is not convincing... I used the MySQL console for testing...and I based the time result also... 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
