On Thu, 1 Apr 2004 13:20:37 +0000 (UTC), Jesper B. Kiær wrote:

> I'm looking into Firebird and I really like what I see and I want to
> use Firebird in my future projects.
>
> I come from a Lotus Notes world where it is normal to have hundreds or=20
> thousands of databases on a server.
> What about firebird? Can you do that without problems ? RAM usage?

With the SS version you'll use RAM for each _currently open_ database at
<pagesize>*<no_of_cache_pages>. If your databases all use 4KB pages and
you specify 4K cache pages, each will take around 16MB - not a lot.
You can have as many databases as you like - if they are closed they will
not use any RAM resources.
If you intend to open hundreds of databases simultanously - do the math :-)

> Using the ALIAS feature is fine to avoid pointing to a physical path
> on the server. If I need to get a listing of aliases from the
> server....is this possible from a client?

Don't think so.


--
Aage J.