Re: Millions storage...
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
Subject
Views
Written By
Posted
2617
March 28, 2005 03:02PM
1778
March 28, 2005 07:53PM
Re: Millions storage...
1946
March 29, 2005 07:18AM
1894
March 29, 2005 07:28AM
1768
March 30, 2005 12:50AM
1805
March 30, 2005 01:16AM
2000
April 01, 2005 12:51AM
1932
March 31, 2005 07:44AM
1769
March 31, 2005 11:34PM
1833
April 01, 2005 09:07AM
1876
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.