Do Empty Fields in an ADO Rs use much memory?
Say I have a manufactured client side recordset with two nullable fields (let's call them Simple and Complex). One of the fields is always left empty since the Simple field is used for storing simple data types (converted to a string) and the Complex field is used for storing binary data (adLongVarBinary).
Also, the average number of rows would be less than 250 and mostly simple data.
AOT: This is the type of problem that sometimes stops me from getting more things done, since I am sometimes a victim of the early optimization itch. It's probably a difference of like 1KB of memory for the whole recordset.
So did you run the tests? Willing to share results?
The single adLongVarBinary field recordset used 92K more memory for a 250 row recordset than a recordset with two fields. (it used 60K less than the 2 field rs, when I didn't store strings binarily as unicode).
The differences in memory usage are pretty significant it seems. However, having in mind that the recordsets are usually way smaller then the tables) it's OK.
Fog Creek Home