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