I agree that in a usual application it's not likely to matter that much, but for
short and mostly trivial OLTP I bet it's measurable. Your single row insert
through ODBC kinda logic the trigger can significantly increase the pathlength
even cross compiled to C.
Also keep data load in mind.....
Bad application maybe. But changing that old Sybase/MS application is expensive
:-)
As always the backend has dictated the app implementation , so in a migration
scenario you won't have any other before trigger logic (because SQL Server
doesn't have them).
I think identity and sequences both have their place in the world.
Identity already is standardized and sequences are in the works.
But I digress...
Cheers
Serge
--
Serge Rielau
DB2 UDB SQL Compiler Development
IBM Software Lab, Canada
Received on Mon Apr 29 2002 - 07:28:19 CDT
