Re: [firebird-support] Re: database in external USB HDD

[Alexandre Benson Smith]

Are you sure you are not mixing it with using the database on Pen Drives ?

Em 4/7/2012 19:10, Sergio escreveu:
 I use FB 2.01 in external USB drive connected to the server for about 3-4 
 years. No problem at all, I think FB 2.5 won't be a problem too.

 Currently, using FB 2.5 on a RAM Disk (in server) for a better speed.
 Thanks for the answer!! If memory serves, I think I read somewhere a post 
 from Helen Borrie in which she says that is not a good idea... But can't find 
 that post now! :(

 Thanks again!

 sergio




 

 ++

 Visit http://www.firebirdsql.org and click the Resources item
 on the main (top) menu.  Try Knowledgebase and FAQ links !

 Also search the knowledgebases at http://www.ibphoenix.com

 ++
 Yahoo! Groups Links

Re: [firebird-support] Re: database in external USB HDD

[Alexey Kovyazin]

Hello All,

To let you know our opinion (from the point of view as recovery products 
and services company):

 On my experience :

 1) USB HDD : more reliable, more speed and more space.


USDB HDD can be used only for backups. Database should be on RAID1/5/10 
(according to your budget).


 2) Pen Drive : more compact.


Welcome to our recovery service :)


 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.

With best regards,
Alexey Kovyazin
IBSurgeon
www.ib-aid.com




[Non-text portions of this message have been removed]