PDA

View Full Version : Temp Spider table Converted to HEAP table


GunMuse
04-22-2005, 01:25 PM
Temp spider table should be converted to using HEAP.

Since your using 4.1 as a standard.

Add some extra fields for breaking up the long text into multiple VarChar and putting it back together to read and store later. We are doing this now with our search where we parse 12 other searches in real time. By avoiding the Harddrive with temporary storage. The load on the server drops dramatically. No sense beating up a harddrive when you don't have to.