Hello! I've used 8 bit datatypes/record as flags in SQL7. So the 8 variables are stored in one byte. So far, so good. But I want to store the 8 variables, along with a couple of varchar datatypes in a CF Structure in RAM. Currently, the 8 bit vars are either 0 or 1. I elected not to allow nulls. I have a little over 100,000 records now, and doubt I'll go over 120,000. ColdFusion memory went to 300MB when I recently populated the Structure. I'll probably have less that 10,000 records with a non-zero bit var, and few of these will have more than 1 of the 8 bit vars non-zero. So my question is, would I save a lot of RAM if I allow NULLs in the bit vars in the DB? best, paul ------------------------------------------------------------------------------ Archives: http://www.eGroups.com/list/cf-talk To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
