What's the reason you have to insert 1m records once a week? If the
reason is something like receiving a CD through mail every Tuesday,
then you of course may have to insert once a week. But quite often
there are some historical (and now irrelevant) reasons for massive
inserts rather than doing small inserts more often (e.g. 100 inserts
every minute).

Set

--- In firebird-support@yahoogroups.com, "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 ?