Re: Millions storage...

[Vinicius Marques De Bernardi]

Yes I think that you got the point...

I will try InnoDB and after I will look for MERGE

And I will take a look at my_large.cnf

Answering your questions I have positions of each vehicle per 30 sec. and I store every positions, so I have something like 3000 rows per vehicle.

The reports are
* LAST POSITION - all the time , but I have a table with the last position for a very speed use HEAP.
* 1 VEHICLE / PERIOD OF TIME (1 day , few hours or a month ) and this are the most common querys
* SOME VEHICLEs / PERIOD OF TIME ( few hours )

The key's used for search are :
VEHICLE ( 1 or more )
DATE_TIME_GPS ( period all the time )
and in some cases I have information like (motor fail) that is a BIT in a BYTE that I have to test using LOGICAL OPERATORS, but this search is not the biggest problem, but always using VEHICLE and DATE_TIME_GPS

Now I think the problem is explained

If need more information, fill free

Thanks for your answer

Vinicius Marques De Bernardi