Subject | RES: [firebird-support] Re: Optimizing Firebird for SSD |
---|---|
Author | Doychin |
Post date | 2011-12-30T07:45:10Z |
If you use Linux as Database OS you can create ram disk very easy. It is part of the OS. There is no limitation for the size. Only the available RAM memory is your limit.
When you use RAM disk you can set the size of your database cache to some small value because all data is already in the RAM.
Also there is the option of shadow files. You can create a shadow file to fast HDD instead of doing backups very often.
In this case you can resume your operation by just copying the shadow file in the RAM disk on next reboot.
In this scenario you will have very fast read but again slow writes.
Again the best scenario is to use RAID 10 with good RAID controller. This gives you enough speed on both read and write and protection against power failure.
Doychin Bondzhev
When you use RAM disk you can set the size of your database cache to some small value because all data is already in the RAM.
Also there is the option of shadow files. You can create a shadow file to fast HDD instead of doing backups very often.
In this case you can resume your operation by just copying the shadow file in the RAM disk on next reboot.
In this scenario you will have very fast read but again slow writes.
Again the best scenario is to use RAID 10 with good RAID controller. This gives you enough speed on both read and write and protection against power failure.
Doychin Bondzhev
--- In firebird-support@yahoogroups.com, "karolbieniaszewski" <liviuslivius@...> wrote:
>
> Here is link to good Ram Disc software
>
> http://www.romexsoftware.com/en-us/vsuite-ramdisk/download.html
>
> there is free version up to 4GB Ram Disc
> if you need bigger you must buy it - but price is not big
>
> Karol Bieniaszewski
>
> --- In firebird-support@yahoogroups.com, "Fabiano" <fabianoaspro@> wrote:
> >
> > I mean: How to create a ram disc?
> >
> >
>