Re: Large Tables(>1 Gb)

Fred_Zellinger@seagate.com wrote:

> However, there is still something bugging me.  Even though many people
> related stories of 7.5 Gb+ Dbs, I still can't make that little voice in me
> quit saying "breaking things into smaller chunks means faster work"
> theories.
>
> There must exist a relationship between file sizes and DB performance.

If your data doesn't completely fit into main memory, at least some of
it will have to be saved off-line somewhere.  Your question is: should
the off-line portion be split into more than one file to speed
performance?

I won't try to be precise here.  There are good textbooks on the subject
if your interested.  I've just been reading one, actually, but it's at
home and I don't remember the name :(  Knuth would of course be good
reading on the subject.

Maybe think of it this way: what's the difference between one file and
two, really?  You've basically just got a bunch of bits on a block
device, either way.  By saving your data to a single file, you have more
control of the data layout, so you can organize it in the manner most
appropriate to your needs.

________________________
Ron Peterson
rpeterson@yellowbank.com