Hi Martin,

I think that having the database resident in memory would be the wrong
approach to a problem such as this. I would be looking at your query and
indexes for optimization, keeping the database in memory would only
introduce more problems (in my opinion) such as writing the changes back to
disk and the scalability of the database (not to mention the system
performance degradation from halving the available memory).

As for the query time now taking 10 minutes instead of 30 seconds, I can't
help you there. Helen, Ann?

Cheers,

Ryan Thomas
TransActive Systems

P: (02) 4322 3302
F: (02) 4325 1141
E: ryan@...
W: http://www.transactive.com.au/

> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ing.
> Martin Straka
> Sent: Friday, 30 September 2005 6:33 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Tuning - How to store database to the RAM
>
> 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
> --------------------~-->
> Get Bzzzy! (real tools to help you find a job). Welcome to
> the Sweet Life.
> http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>
>
>
>
>
>