Subject Maximum number of fields per table
Author Lee Jenkins
Hi all. Looking at the following article:

..and specifically the portion which indicates "Maximum number of columns per

"Depends on data types used. (Example: 16,384 INTEGER (4-byte) values per row.)
NOTE :: 8-byte ID is stored for each BLOB or ARRAY reference; size of BLOB or
ARRAY data is not counted in row size."

Sorry, I'm not certain what this is saying? That with Integer type columns, you
could have 16,384 columns? That seems like a lot.

I'd need to store somewhere around 200 SmallInt columns in a table, which is why
I'm asking. Just doing some research to see if that would be feasible.


Warm Regards,