> > 2) Pen Drive : more compact.
> >
>
> Welcome to our recovery service :)

Yes, Pen Drive is really not reliable, prepare to lost you data if you using this media, that why I said USB Hardisk is more reliable compare to Pen Drive :)

>
> >
> > 3) RAM Disk : highest speed but risky and less space. Do not use it
> > unless you aware of the risk. Runs on a dedicated PC (no other
> > programs run on this pc, only database server and OS), backup it
> > everyday, twice a day and have a reliable UPS. Love the speed when
> > doing maintenance (backup/restore) - superb compare to those two.
> >
>
> We have tested RAM Disks - no performance advantages found when
> comparing to the properly tuned Firebird.
>

Strange, I have a sample database that showing the speed when backup/restore in RAM Disk is much more faster compare to disk, about 20 or 30 times faster perhaps, may be my Disk is too slow, it is SATA II anyway :)

About performance, assuming same database (one on the RAM and the other on the disk), I think it has something to do with database cache memory. If most of data can fits in cache memory, of course, no performance gain since both processing took place on RAM.

incendio.