Subject Re: [firebird-support] Hardware for firebird
Author Aage Johansen
as1616z wrote:
> Hello,
> I need to do every week a massive "INSERT INTO" of 1 million records.
> I need to insert a row per time because additional queries and
> complex calc). This is a very hard and long work and is important to
> save the maximum time of process.
> Is a raid 5 with 4 SCSI HD 15000rpm a good option ?
> Increase ram memory up to 4GB can improve significatively this work ?
> Any ideas ?

Increasing RAM will probably not improve things much.
I suppose you cannot deactivate indexes during the insert process, and it
is a pity if you cannot insert at least a few thousand records between each
Check index depth (and if necessary adjust page size).
15krpm discs is probably the fastest you can get. I don't know which RAID
configuration is the fastest (for inserts), and you might not benefit a lot
from caching in the RAID controller if you need to commit for every record
Fast processors (of course) and as much cache on the processors can prove
valuable. I think many processors now come with 2MB (earlier, 512KB - 1MB
was common).

Do you run it locally on the server (to eliminate network
limitations)? With multiple processors you can have the insert programs
run on a separate processor (different than the one Fb server is using).
Can you split the data and run several insert programs in parallel?
Can ForcedWrites "safely" be turned OFF during this process?

Aage J.