Max Wanadoo
max.wanadoo at gmail.com
Mon Dec 31 10:11:53 CST 2007
I think that the main cause of bloat is the use of Memo Fields. If you have no Memo Fields then bloat is very small. When Access writes data to a Memo Field it appends it to the end of the current contents, effectively skipping what was there before. This is in order to increase (apparent) speed. Every time you enter/exit a Memo Field it increases it size even if you only change one byte. A 1Kb field become 2Kb then 4Kb and so on. Compact eliminates and reduces the Memo field back to its current contents. If anybody knows different I would love to hear it. Thanks Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Monday, December 31, 2007 4:03 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Compact and Repair on Close The main reason for compact on close in FEs is to get rid of the bloat caused by running queries, running reports (which runs additional queries), and all the temporary queries Access plays with behind the scenes. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at Beach Access Software Sent: Monday, December 31, 2007 5:34 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Compact and Repair on Close Dear List: I have a legacy app that was set up to compact and repair on close. I found it annoying during development - the delay every time I closed and re-opened the app. So I disabled it. The program will eventually become an mde and will be distributed to a vertical market. Q: is there any reason to C&R on exit? I know it gets rid of the 'bloat' - but IME that bloat is mostly inconsequential in terms of execution time. There are very few front end tables in this app - it's all back end. Or is there some other good reason to turn this C&R on Exit feature back on? MTIA Rocky -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com