Hi Folks, We have three tables where will have lot insertions per minute. In all three tables we have TIMESTAMP columns, And we kept index for these timestamp columns. This timestamp values always system time when the row is inserted.
My doubt is whether maintaining the index tree for this kind of data (timestamp) will be overhead for derby database. Because Timestamp contains including seconds also right, I feel personally to create index structure & maintaining this structure could be little overhead for derby server. Please correct me if I am wrong. In this scenario how to improve performance while huge insertions happening into these tables. Thanks in Advance. Regards Sekhar. -- View this message in context: http://apache-database.10148.n7.nabble.com/Index-for-TIMESTAMP-COLUMN-tp143572.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
