General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>James;
>
>How do you generate the header to ensure uniquess? I am curious because I have an application that has users in the field (no possible way to access the network) for up to 2 weeks at a time and I may want to consider your idea for some of our tables.
>
>I forgot to respond this to your prvevious post: a surrogate integer keys is faster than a surrogate GUID but it is slower than a natural key when it requires an additional join... Don't get me wrong, I almsot always use surrogate keys for the main table but I will use a natural key for secondary tables when it makes sense.
>
>Daniel
I create a table called ID. For each table that requires a pk, an entry is created where the next value is stored. In the database I have a procedure that increments that value and returns it to the client.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only