Re: Problems with indexing a timestamp() field

2003-09-30 Thread Peter Rabbitson
It is not quite possible - there are several hundred packets per second - hence several hundred fields with equal timestamps. In order to use primary key all fields have to be unique... Peter On Tue, Sep 30, 2003 at 03:39:08PM -0700, James Kelty wrote: > Maybe making it the PRIMARY KEY will hel

Problems with indexing a timestamp() field

2003-09-30 Thread Peter Rabbitson
Hello all, I am trying to set up a complete trraffic accounting using Ulogd-mysql. Since the whole idea of the project is to be able to select rows based on the timestamp value indexing is a must. The index files get created with no problem at all. However explain select refuses to use the ind