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(107397)
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]