Sudheer Palaparambil wrote:

>...No BLOBS...15000 records...daily.
>
>
>

Nothing to worry about here. *Any* disk will handle your batch
insert in less than 5 minutes. I have a batch process in a customer
running every two hours. The process allways completely delete a
table and then inserts over 60K records. Table is very simple
Char(6) on PK, VarChar(120) on a atribute. The whole process
take 6-10 seconds with no load on machine. Under heavy load it
take 3-5 minutes. SCSI disks, no RAID.

Of course, your times will be bigger since you are not gonna
clean your host table every time :-).

If you wanna realy scratch your head, think about the selects you
will perform against that table. The batch insert is not the problem.

> Also let me know the size of memory.
>
>
>

People often recomends the maximum memory you can get, but,
personally I never managed to reach 256MB memory usage.

>Sudheer Palaparambil
>
>

Ivan