albertocolom / elmah

Automatically exported from code.google.com/p/elmah
Apache License 2.0
0 stars 0 forks source link

Empty Access database needs compacting #59

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
The Elmah.mdb is a whopping 6.51 MB even though it should be and is a 
datable with a single empty table. I did a "compact and repair" using 
Access 2007 and the size went down to 228K. It still seems a lot but is a 
lot more reasonable than 6.51 MB (especially as a binary blog sitting in 
Subversion). I didn't commit the compacted version as I wasn't sure which 
version of MS Access was used to build the original and whether compacting 
with Access 2007 would tie it to that version alone or not.

Original issue reported on code.google.com by azizatif on 7 May 2008 at 9:32

GoogleCodeExporter commented 8 years ago
Do we even need to provide an empty MDB file? Could this not be dynamically 
created 
with, for example, a WSH script in VBScript or JScript using ADOX?

Original comment by azizatif on 7 May 2008 at 9:58

GoogleCodeExporter commented 8 years ago
Resolved the size issue. Have run compact and repair on the .mdb twice, which 
pulls 
it down to 224K.

Will investigate creating the .MDB on the fly. Therefore reducing the priority.

Original comment by jamesdriscoll71 on 7 May 2008 at 10:18

GoogleCodeExporter commented 8 years ago
Also, changing type to enhancement!

Original comment by jamesdriscoll71 on 7 May 2008 at 10:18

GoogleCodeExporter commented 8 years ago
We can consider this issue, as per its original subject, fixed. I have ported 
the 
idea of creating the MDB programmatically over as issue #60 so it can be 
tracked 
separately.

Original comment by azizatif on 8 May 2008 at 6:07