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.
| Author |
Topic |
|
BoobBoo
Starting Member
2 Posts |
 Posted - 2009-07-16 : 10:33:14
|
| 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 tableOr 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 useTIAChris |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
GPS Application database