MySQL Forums
Forum List  »  Partitioning

PARTITION or sEPERATE tABLE ISSUE
Posted by: hrishi patil
Date: October 29, 2009 06:07AM

Hi,
I am developing a fleet management system.So In this case I will be getting a record every 3rd second for a single vehicle And there will be n vehicle...so i will be getting n no of record every 3rd second. All this record i will be storing in CURRENT_LOCATION table.That means i will have millions of record in my table.
To handle this (Performance wise) I got few suggestion.
1>Create a seperate table per vehicle .

Options: ReplyQuote


Subject
Views
Written By
Posted
PARTITION or sEPERATE tABLE ISSUE
3045
October 29, 2009 06:07AM


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.