Re: Database Size Limit

[Aaron Brick]

> Yes and no.  With 3.23, the MyISAM format will, by default, have a 4GB
> limit (32 bits).  You can set flags on the table to allow a 64-bit table,
> and you'll generally hit an OS or physical limitation long before you 
> run out of space.  The downside of the 64-bit version is it's considerably
> slower.  Better to split large datasets up into sub-4GB units. 

why are operations on the >4GB tables slower?

and, incidentally, where is that flag set?

thanks,

aaron brick.


                ________________________________________________
               /                                                \
              |   Aaron Brick                 (415) 206 - 4685   |
              |   brick@stripped         Room 3501C, SFGH   |

                  Programmer Analyst, Functional Genomics Core  
                   Sandler Center for Basic Research in Asthma
                   Lung Biology Center, Department of Medicine
                                San Francisco General Hospital
                       University of California, San Francisco