maximum heap table size allowed

2001-12-28 Thread Banach, Timothy P

 Hello,
 
 Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the 
documentation apply equally to HEAP tables in v. 4.0?
 
 Or, rather, if memory and address space were unlimited, how large could a heap table 
possibly be in v. 4.0?
 
 TIA
 
 Tim Banach
 State Street Corporation
 Westwood, MA
 

-
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




Re: maximum heap table size allowed

2001-12-28 Thread Sinisa Milivojevic

Banach, Timothy P writes:
  Hello,
  
  Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the 
documentation apply equally to HEAP tables in v. 4.0?
  
  Or, rather, if memory and address space were unlimited, how large could a heap 
table possibly be in v. 4.0?
  
  TIA
  
  Tim Banach
  State Street Corporation
  Westwood, MA
  
 

Hi!

It is the same. Just use MAX_ROWS 

-- 
Regards,
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED]
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Fulltime Developer
/_/  /_/\_, /___/\___\_\___/   Larnaca, Cyprus
   ___/   www.mysql.com


-
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




maximum heap table size

2001-12-27 Thread Banach, Timothy P

Hello,

Can anyone tell me if the maximum table sizes given in Section 1.2.4 of the
documentation also apply to HEAP tables in v. 4.0?

Or, rather, if memory and address space were unlimited, how large could a
heap table possibly be in v. 4.0?

TIA

Tim Banach
State Street Corporation
Westwood, MA


-
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