I am using a scheme set up with GUIDs on MS SQL Server. I am trying to debug some slow DB inserts, and I want to understand how the DB obtains these GUIDs.
My UUT_RESULT insert statement is configured to use a command to insert the record. It looks as though it would need to obtain the GUID ahead of time and provide it in the INSERT statement, and then TS would have it to use in the STEP_RESULT/STEP_SEQCALL tables. But does it call a DLL library function to obtain the GUID? Does it make a call into the DB driver to obtain it? Does it run a query to obtain it?
When writing my own tools to mod this DB from other processes, I wrote a query that would create and return N GUIDs that I could pre-populate into my insert statements. Is this how it's done?
I think that it might be FK lookups that are slowing the inserts, but I am not sure, and I need to start somewhere.
