I cant seem to find anything via a google search, so if this has been answered I apologize.
I am wondering if INDEX=MEMORY is going to give the best performance versus files? I have a server with directly attached storage, 8 gigs of ram, about 500 gigs of data. I am ok with losing and having to rebuild the indexes on a reboot as the last uptime was over 200 days
