Hey all. I'm trying to speed up a search I'm running with about 400,000 records. The full text catalog is about 140 MB in size and takes up to 4 or 5 seconds to process most searches. So I'm trying to put the full text catalog into a RamDrive called RamDiskNT by CenaTek to speed up the results. (Assuming its the 7200 RPM hard drive slowing the search down. I figure I have a 2.4 P4 processor and that should be enough horsepower to run this search.)
Only problem, when creating the full text catalog on the Ram Drive it throws the error "Access is denied to 'z:\', or the path is invalid."
Anyone have success putting a full-text search into some sort of Ram Disk product? Or anyone have success doing something similar to speed up their search results?
Only problem, when creating the full text catalog on the Ram Drive it throws the error "Access is denied to 'z:\', or the path is invalid."
Anyone have success putting a full-text search into some sort of Ram Disk product? Or anyone have success doing something similar to speed up their search results?