View Single Post
Old 04-22-2005, 01:25 PM   #1
GunMuse
Green Mole
 
Join Date: Feb 2005
Posts: 24
Temp Spider table Converted to HEAP table

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.
GunMuse is offline   Reply With Quote