|
04-22-2005, 02:25 PM | #1 |
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. |
Thread Tools | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
No link in temporary table (yet another one) | renehaentjens | Troubleshooting | 7 | 03-30-2004 11:46 PM |
Table engine missing | vladone | Script Installation | 2 | 03-30-2004 11:38 PM |
Table descriptions | motopsycho | How-to Forum | 1 | 03-10-2004 10:01 AM |
Link to another table | Not Logged In | How-to Forum | 4 | 11-28-2003 11:30 AM |
Temporary Table | jimigisme | Troubleshooting | 3 | 11-07-2003 02:32 PM |