Quote:
Originally Posted by aZooZa  Ken, it may be worth getting a 60Gb drive attached. You can then tell the unix sort to use that drive for the temporary files created during the sort routine. The extra drive is a better solution than a 'bigger' drive if you ever decide to upgrade. |
thanks for the tip Dale. i should have moved the sort to the Unix side of things a long time ago. Unix does it much more efficiently and it only needs to be done once daily as the data is loaded instead of on each query request.