> > > What is volume of imported data ?
> >
> > about 200Mb per day
>
> You need about 30 hours to import ONLY 200Mb ???
For each record imported there can be up to 75 'lookups' and/or insertions,
and up to 50 calculations, all done in stored procedures.
> Have you tried to tune the db enough ? Like not count all rows in each
> trigger :-), drop fk constraints with low selectivity indexes, and such
> things ? (or more nasty tricks like denormalize the tables ...)
The database works very will on Solaris and Linux, but we just have a
potential customer that wants to run the thing on Windows, and I not keen on
writting a 'special versin' just for him.
Phil
--
Linux 2.4.4-4GB
5:18pm up 6:12, 1 user, load average: 0.82, 0.32, 0.19