> 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?
| 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