But with DROBO, the harddrives are installed, hooked up via USB2 or firewire, then it has its own driver that makes the OS recognize it as just another hard drive.
Then I will simply drop the AC data base there? And it should work, perhaps not as fast as if it were in the AC program file, in the computer on the same hard drive as the OS?
For Drobos, I have implemented a couple, and they are generally very effective for their price point. If you don't have a firewire port, it is *well* worth the cost of getting one for the performance improvement.
My bride has one that she uses in her Mac based editing environment - it takes a minimum a 3TB array to edit larger projects.
THe other implementation is a smaller enterprise setup where the Drobo is near-line storage of recent backups before the backups are run off to a tape drive.
the only real downside is that it uses it's own proprietary software, so the end-user has very limited control.
For your purposes a Drobo with Firewire is probably a good fit.