Results 1 to 2 of 2
Thread: Sql Server Tmp Tables
Jun 3, 2008, 13:04 #1
Sql Server Tmp Tables
I am developing an application which uses sql server temporary tables for it's search option.
What I need to know is does sql server create temp tables for each website visitor separately?
If two visitors are on search page searching by different criteria, does sql server create separate temp table for both visitors?
Jun 3, 2008, 14:11 #2
- Join Date
- May 2003
- Washington, DC
- 4 Post(s)
- 0 Thread(s)
It depends on which sort of temp tables you use. I haven't used them in a while so I don't recall the specifics, but one has a scope of the current execution context and the other is a bit more persistent.
That said, temp tables are a rather expensive way to do search. How are you using them?