I am designing a database for a GPS application which will store GPS co-ordinates from many different sources/recievers.
My question is, should I compile all the various GPS inputs into a single (potentially) very large table
Or should I create a smaller tables for each individual transmitter and then a master table to hold the details of each smaller table.
My initial thought is to use the many smaller tables as it will lead to less contention within the table and also less problems when it comes to locking as not all database connection menthods are equal when it comes to lock strategies.
Does anyone have any suggestions or know of any designs that are in the public domain, for use