PARTITION or sEPERATE tABLE ISSUE
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 .
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.