|
|
Posted by David Cartwright on 10/08/05 13:47
"laurenq uantrell" <laurenquantrell@hotmail.com> wrote in message
news:1128703331.710695.156120@f14g2000cwb.googlegroups.com...
> Is there any reason to have a row that is the PK/Identity and a row
> that is datatype Timestamp in the same table?
> Does this in any way help speeding up row updates?
Can't see that adding a timestamp field would speed anything up - in fact
the presence of a field that is auto-populated means that, by definition,
every time you INSERT or UPDATE the row, it'll have to do some work writing
the current date and time to the table.
A timestamp is, of course, useful as a "last modified date/time" indicator
for your applications, though.
D.
Navigation:
[Reply to this message]
|