I am designing a database which will have many inserts and selects, but no updates.
Are there any considerations to take (in order to have high query performance) while knowing no tuple updates will occur?
There is one simple table, of
int (id),timestamp,real, there will be about 100 inserts per second.
timestamp is not the insertion time, the int is a random short number.
Most of the queries are selection of data between two dates (1 minute - 1 week), for a group of id (up to 10).