I have been doing some .net performance tests on a bunch of different data access frameworks.
One of the things I've noticed is that performance when accessing the tempdb table in SQL is much quicker than when using a regular table. I'm not too sure why this is but it appears that when entityFramwork (one of the frameworks) sets up its connection with
-- network protocol: TCP/IP set quoted_identifier on set arithabort off set numeric_roundabort off set ansi_warnings on set ansi_padding on set ansi_nulls on set concat_null_yields_null on set cursor_close_on_commit off set implicit_transactions off set language us_english set dateformat mdy set datefirst 7 set transaction isolation level read committed
The performance is reduced to that of a regular table.
Does anyone have any idea why this would be?