List:General Discussion« Previous MessageNext Message »
From:Aaron Brick Date:January 11 2002 7:19pm
Subject:Re: Database Size Limit
View as plain text  
> 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
Thread
Database Size LimitManish Mehta11 Jan
  • Re: Database Size LimitDan Nelson11 Jan
    • Re: Database Size LimitJames Montebello11 Jan
      • Re: Database Size LimitAaron Brick11 Jan
        • Re: Database Size LimitJames Montebello11 Jan
          • Re: Database Size LimitBenjamin Arai13 Jan
Re: Database Size LimitDemirchyan Oganes-AOD09811 Jan
  • Re: Database Size LimitBenjamin Arai13 Jan
    • Re: Database Size LimitAaron Brick14 Jan
      • Re: Database Size LimitJeremy Zawodny17 Jan
Re: Database Size LimitHeikki Tuuri13 Jan