Subject | RES: [firebird-support] Re: Optimizing Firebird for SSD |
---|---|
Author | karolbieniaszewski |
Post date | 2011-12-21T06:34:23Z |
Do you know what is RAM DISC?
If not then "google" for it ;-)
I can simple say that RAM DISC is some virtual disc created in RAM MEMORY.
After creation you use it as normal hard drive (copy database on it and use as normal) with all benefits of RAM speed :)
but you must remember that if power failure or some hardware error occur and your server stop - all data from RAM will be cleared.
Because of that you must do backup in some short interval.
e.g. your database is 3GB you can create RAM DISC 4GB and do backup to normal HARD DISC or better you can create RAM DISC 8GB and do backup to also RAM DISC and when backup process completed simple copy backup file to HARD DISC what is tone faster.
RAM is now cheap - but i do not know what is your database size and what scenario can be accomplished.
If not then "google" for it ;-)
I can simple say that RAM DISC is some virtual disc created in RAM MEMORY.
After creation you use it as normal hard drive (copy database on it and use as normal) with all benefits of RAM speed :)
but you must remember that if power failure or some hardware error occur and your server stop - all data from RAM will be cleared.
Because of that you must do backup in some short interval.
e.g. your database is 3GB you can create RAM DISC 4GB and do backup to normal HARD DISC or better you can create RAM DISC 8GB and do backup to also RAM DISC and when backup process completed simple copy backup file to HARD DISC what is tone faster.
RAM is now cheap - but i do not know what is your database size and what scenario can be accomplished.
--- In firebird-support@yahoogroups.com, "Fabiano" <fabianoaspro@...> wrote:
>
> How put the entire database on RAM Disk?
>
>