IUBio

big databases

Ed Griffiths edgrif at sanger.ac.uk
Tue Oct 15 05:25:18 EST 2002


Keith,

> Any word from the acedb guys as to whether they fully endorse
> this??? I.e. would there be any unforseen side effects (slower access
> times maybe?).
>
> I'll try to test this with our large database at some time and will report
> back any speed gains in loading time.


There is no reason not to have larger files, you just need to be aware that
having very large files (> 1GB) can cause problems on some operating systems.
Its a little hard to say why there is such a speed up on Daves system without
doing some investigation but I would bet that because the speed up is so
appreciable its something to do with large files being less scattered across the
disk resulting in faster access times because the disk drive heads have to do
less seeking. But really that's all just hand waving. Its certainly worth a try.

I guess we don't give advice on this sort of stuff because it is usually quite
system specific.

cheers Ed
-- 
 ------------------------------------------------------------------------
| Ed Griffiths, Acedb development, Informatics Group,                    |
|        Wellcome Trust Sanger Institute, Wellcome Trust Genome Campus,  |
|               Hinxton, Cambridge CB10 1SA, UK                          |
|                                                                        |
| email: edgrif at sanger.ac.uk  Tel: +44-1223-494780  Fax: +44-1223-494919 |
 ------------------------------------------------------------------------





More information about the Acedb mailing list

Send comments to us at biosci-help [At] net.bio.net