Re: prime number table

2010-09-21 Thread Elim PDT
descript is a great idea. thanks again! - Original Message - From: "Chris W" <4rfv...@cox.net> To: "Elim PDT" Cc: Sent: Saturday, September 18, 2010 6:57 AM Subject: Re: prime number table Keep in mind that to store a number as a 32 bit unsigned intege

Re: prime number table

2010-09-18 Thread Chris W
Keep in mind that to store a number as a 32 bit unsigned integer takes 4 bytes of data no matter how small or large that number is as long as it is less than 4,294,267,296. If you store numbers as a string like it is in your file it takes 8 bits per digit so for 19,999,999 it would take 8 byt

RE: prime number table

2010-09-17 Thread Gavin Towey
The data isn't in the .frm; That only holds the structure of the table. Your data is in the .MYD file of the same name, and indexes are in the .MYI file. -Original Message- From: Elim PDT [mailto:e...@pdtnetworks.net] Sent: Friday, September 17, 2010 11:29 AM To: mysql@lists.mysql.com S