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