RE: how many colums can i create before it becomes unusable?

2001-01-26 Thread Scott Gerhardt
Hello Anna, According to the MySQL Crash-Me the maximum numbers for 3.23.xx are: - Columns in table 3398 - max table row length (without blobs) 65534 - table row length with nulls (without blobs) 65502 If you understand the concepts of DB normalization don't bother reading the following: 300

RE: how many colums can i create before it becomes unusable?

2001-01-26 Thread The Tilghman
It may become less readable on the server side, but if you want to store lots of little bits of information, use a BIGINT column as a collection of a bunch of bits ... pack and unpack them in your application. For searching, use the bitwise operators to do comparisons. -Tilghman -- "There cann

how many colums can i create before it becomes unusable?

2001-01-26 Thread anna soobrattee
hi, i've been asked to design a for a new web-based system which stores lots of data on it's members. There are currently about 500,000 member records. the problem is that i have to store at least 248 pieces of information on each user. i've made the system as relational as possible so that