Subject | Re: [firebird-support] Tuning - How to store database to the RAM |
---|---|
Author | Steve Wiser |
Post date | 2005-09-30T12:09:26Z |
Hi,
We did a test under linux where we put 8 GB of RAM into a server to
see if the database performed better on a disk where the server had a
lot of RAM or where a RAM disk was created and the entire database was
kept on that RAM disk. What we found was that our tests were identical
under each case as it looked like linux was caching as much data as it
could and was in effect moving the database to RAM automatically. I
think the concept of RAM disks and databases completely in RAM may not
pan out like you think it will. We were very surprised at the
results...
-steve
We did a test under linux where we put 8 GB of RAM into a server to
see if the database performed better on a disk where the server had a
lot of RAM or where a RAM disk was created and the entire database was
kept on that RAM disk. What we found was that our tests were identical
under each case as it looked like linux was caching as much data as it
could and was in effect moving the database to RAM automatically. I
think the concept of RAM disks and databases completely in RAM may not
pan out like you think it will. We were very surprised at the
results...
-steve
On Thu, 2005-09-29 at 22:32 +0200, Ing. Martin Straka wrote:
> Hallo Friends,
>
> I need to speed up my firebird answers to sql select questions. I
> thing,
> that the best way is to store full database to the memory.
> The size of my database is 800 MB, amount of server memory is 1.5 GB
> so it
> should work I think...
> I use the 1.5 Release Superserver (connected about 20 clients) on
> windows
> 2003 server. I tryed some changes in firebird.conf, no result.
>
> Sooner I used 1.0 Release Classic Server, the database was intitiately
> fully
> loaded to the memory and answers to some complicated sql questions was
> much
> quicker (now 10 minutes, previously 30 seconds). Now it don't works, I
> don'n
> know why (even if i use the same firebird.conf from previous
> version).
> Does anybody knows? Some solutions of my problem?
>
> Thanks much
> Martin
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net 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
>
>
>
>
>
>
>
[Non-text portions of this message have been removed]