The index is on dtime only. I've done some testing and dual-column indexes using id and dtime are significantly faster. However, I'm not one of the developers of this package - RTG. I have reported the speed increase to them, though.
In the meantime, I'm trying to run a "standard" system so I'm hesitant to modify the index structure. I don't want to run into problems with future revisions. Right now, I just want my existing indexes to work. Jack -----Original Message----- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 2:01 PM To: [EMAIL PROTECTED] Subject: Re[2]: Index not functioning Hello Jack, Wednesday, March 24, 2004, 6:50:45 PM, you wrote: JC> I tried using 'USE INDEX' and 'BETWEEN' but it didn't change anything. JC> EXPLAIN SELECT counter, UNIX_TIMESTAMP(dtime) FROM ifInOctets_137 JC> USE INDEX (dtime) WHERE id=2809 AND dtime BETWEEN FROM_UNIXTIME(1073970000) JC> AND FROM_UNIXTIME(1076734799) ORDER BY dtime; Does your index include both id and dtime in a single index? If not, it probably ought to if the above is a typical query you need to run on this table. -- Best regards, Richard Davey http://www.phpcommunity.org/wiki/296.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]