Subject Re: [firebird-support] Hardware for firebird
Author Alexandre Benson Smith
as1616z wrote:

>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 ?

If maximum performance is the goal I would go for RAID 0, if money is
not a problem then I'd go for RAID 1+0

RAM is always good.

Could you tell us more detail about the complex calc and aditional queries ?

Did you tried a multi-threaded application to insert this records ?

The application could run from the same machine and uses a local
connection ?

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil