Re: Optimize complex query with arithmetic calculations

[Miguel Angel Tormo Alfaro]

Few more precissions:
These are network traffic logs of a medium LAN, so there are quite a lot of records. In fact, in one week we have more than 2 million records.

For instance, a query like the following is also slow:

select id from trafico2 where fechahora between '2005-05-30 11:00:00' and '2005-05-30 11:01:00';
...
259 rows in set (7.63 sec)

Maybe making an index from fechahora would improve performance, what do you think?
Any ideas? Thank you.