I have a question to you guys: what drive would be the best choice for database?
I work with Access databases every day, building, merging, copying data between big files, millions records, etc. Some queries take ages to get results, so I thought I could use some SSD drives to make it work faster. But which one?
Thing is I do not work on one database, I work on 5-10 2GB files with millions of records, run hundreds of queries every day. That is why I think RAID won't be good, cause drive would have to clean itself when its idle (TRIM).
So maybe Velociraptors in RAID0? Or any other HHD in RAID0? Hybrids?
I work with Access databases every day, building, merging, copying data between big files, millions records, etc. Some queries take ages to get results, so I thought I could use some SSD drives to make it work faster. But which one?
Thing is I do not work on one database, I work on 5-10 2GB files with millions of records, run hundreds of queries every day. That is why I think RAID won't be good, cause drive would have to clean itself when its idle (TRIM).
So maybe Velociraptors in RAID0? Or any other HHD in RAID0? Hybrids?