I was a bit surprised to see that a database I transferred
from MS SQL to InstantDB was quite large until after I read a few of the
archived list postings related to text storage.
I altered my table schema to use SMALLCHAR types in place of
CHAR and VARCHAR and immediately saw a reduction in the size of individual
tables. However, I also noted an odd drop in size of some of the TEXT
fields which are stored in separate tables/files in InstantDB.
Does InstantDB automatically switch to using single bytes to
store text if any of the text fields are set to use SMALLCHAR?? Or am I
just imagining things.