Hi,

Guess my original question was too lengthy... :-) Trying to put it shorter.

I'm looking for tips re. how to configure my server and DB:
firebird.conf as well as settings in the DB itself (page buffers, page
size...).

The DB has a rather wide table with about 1 million records and a small
child table with 1 (mostly) to 5 (unusual) child records for each master
record.

Only one client (because the client is a server application) with a
single connection on which it will execute only one query at a time. All
queries on these tables are read-only - no updates or inserts, but it
will do insert...select from the master into a third table.

I need to optimize for speed.

The setup is Firebird 1.5.2 superserver, Windows Server 2003 Standard,
Pentium 4 2.80 GHz no hyperthreading, 1 Gbyte RAM, single 7200 rpm disk
200 Gbyte. On the same machine resides IIS + an ISAPI plugin + the
client (my server application). My server application requires about 50
Mbyte RAM. Excluding Firebird, I have about 850 Mbyte free physical memory.

Any recommendations and indications re. tradeoffs are most welcome.

Thanks,
Kjell
--
--------------------------------------
Kjell Rilbe
Adressmarknaden AM AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64