Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Database design for GPS application

Author  Topic  BoobBoo Starting Member 2 Posts Posted - 2009-07-16 : 10:32:37 Hi, 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 TIA Chris