MySQL Forums
Forum List  »  Performance

Re: Millions storage...
Posted by: Vinicius Marques De Bernardi
Date: March 29, 2005 07:18AM

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

Options: ReplyQuote

Written By
March 28, 2005 07:53PM
Re: Millions storage...
March 29, 2005 07:18AM
March 30, 2005 12:50AM
March 30, 2005 01:16AM
April 01, 2005 12:51AM
March 31, 2005 11:34PM
April 01, 2005 09:07AM
April 01, 2005 09:09PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.