Re: File size: Bigger or smaller?

From: Doug Cowles <dcowles_at_i84.net>
Date: 2000/08/03
Message-ID: <gc2koso8aqhokhm79vngqlhuu3tvgnhjp4@4ax.com>#1/1

I think it would depend on at the very least your operating system which you didn't mention. AIX functions better with smaller files around 1GB, but I can't verifiy for others.

On Thu, 03 Aug 2000 22:02:40 GMT, sergey_s_at_my-deja.com wrote:

>Which is better for data warehouse performance: Bigger files or smaller
>ones (2 Gig or greater)? We have a table about 300 Gig in size striped
>over RAIDs. Should we increase the file size from 2 Gig to something
>else? We are running 8.0.6
>
>
>Thank you!
>
>Sergey
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Aug 03 2000 - 00:00:00 CDT