> 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 |
| [EMAIL PROTECTED] 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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
