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]

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
>
>
>
>