MySQL Forums
Forum List  »  Optimizer & Parser

Advice on indexing a datetime column
Posted by: Michaël Ball
Date: July 23, 2010 08:56AM


I am looking into optimizing a database, and I've highlighted a particular 'datetime' column in a table that could benefit from being indexed. However, I would appreciate some advice about whether or not what I intend to do will degrade performance of the table in other areas.

The table stores GPS positions and is being constantly updated with data from hundreds of GPS devices every second. Would indexing on the 'datetime' column of this table greatly affect the speed at which the table processes the data coming in? I am little unsure, as the datetime value should always be sequential (subsequent data coming in will always have a datetime value greater than previous entries in the table). Can anyone offer any suggestions on this?

Options: ReplyQuote

Written By
Advice on indexing a datetime column
July 23, 2010 08:56AM

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.