Hi, I'm doing a query on the following table: +----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+-------------+------+-----+---------+-------+ | time_utc | int(11) | | PRI | 0 | | | prefix | varchar(18) | | PRI | | | +----------+-------------+------+-----+---------+-------+
The query is: --------------------------------------------------------- select prefix, ((time_utc-1004127737) div 86400),count(*)from t129_250_0_11 group by prefix,((time_utc-1004127737) div 86400); --------------------------------------------------------- I'm doing it on a dual processor 2Mhz Athlon 64-bit machine. The only problem is that the table has about 160,000,000 (160M) entries and i'm afraid that disk i/o looking for indexes is taking most of time. The query has been running for almost 10 hours now. Do you have any sugestions that might speed up the query? Do you think removing the indexes will speed up things? Thanks in advance for your help! --Ricardo -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
