It's a difference between insert the data into a table, and returning the data to a client. The latter includes network overhead etc. You should try this before you dismiss my suggestion.
But of course, adding 50000 rows to a session table incurs some overhead, particular when the user only looks at the first couple of pages.
Anyway, you asked for a advice on a query I don't see, on tables I don't see etc. You cannot expect very exact advice in this case.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment