by Ash Nallawalla
In early 2003, I was asked to review the "Corporate" Quickbase template options and present a recommendation to the SPM volunteer Directors. SPM had a total of 18 DBs (15 x 500 kB DBs, and 3 x 10 MB DBs) to work with, within each DB one can have up to 25 members. The questions I had to answer were:
Q. How much does a 500 kB “Standard” DB hold?
A. Each character represents 1 byte. Each empty text field is 4 bytes. Each used text field is a minimum of 4 bytes and a maximum of the actual content size. All non-text fields are a minimum of 8 bytes each. Double-click the embedded Excel sheet below (this is non-functional in the Web version of this article) and enter your values in the yellow fields:
The above sizing exercise had to be done by each team before we could determine that the Quickbase offering would meet everyone's needs. Alternatively, some compromises would be needed.
->Go to Part 3: Evaluation of Options
QuickBase Part 1
QuickBase Part 3
QuickBase Part 4