Jan Kirchhoff <[EMAIL PROTECTED]> wrote on 21/07/2004 13:08:38:
> what a about the very simple approach?
> This should be very fast if you habe indexes on ip, date, time and
> record_type.
I would have though it would be best to have a composite index on
date/time/record_type, which is what both halves of the query will want.
I would expect MySQL to handle this query very well.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
