Re: design question, use of partitioned tables?

"Manuela Mueller" <mueller_m_at_fiz-chemie.de> wrote in message news:bgvu9e$s2t27$1_at_uni-berlin.de...

> Run began on Wed Aug 06 10:23:50 2003
> Run ended on Wed Aug 06 21:22:46 2003
> Elapsed time was: 10:58:55.77
> CPU time was: 00:04:27.47

> Run began on Fri Aug 08 09:56:15 2003
> Run ended on Fri Aug 08 10:42:15 2003
> Elapsed time was: 00:45:59.81
> CPU time was: 00:01:42.08
>
> Ouch!

You got it in one: indeed!
Something to put you in good terms with
your Linux/Unix guru/admin: I do recall an earlier discussion here about nfs where someone mentioned there are some tuning parameters for the nfs server to let it cope better with large volumes, large number of files, frequent reads and no writes, etcetc. Maybe it's worth a poke at these rather than losing the flexibility you have now in mounting the remote fs?

--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam