Project

General

Profile

Bug #3180

Reduce File size by importing to new database

Added by Michael Lee over 11 years ago. Updated about 11 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
03/20/2008
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
3180

Description

It may be possible to reduce the file size by ~10MB by importing all objects into another fresh db. This had problems the first time I tried it, in that once a lot of objects went missing mysteriously (not a good sing) and another time the SQL of queries got rewritten such that it wasn't clear if the SQL was still OK or not (at least one query failed because it couldn't figure out a join).

To tackle the SQL issue, a list of queries with SQL should be made, including rowSource for combo boxes and list boxes. Once that is done, then SQL can be checked, and, when needed, fixed.

My notes:
--delete sections (code, macros, forms, queries, tables) then c&r and see what happens to file size
--this done, and db was still 13MB after all deleted. Trying to import into new.
queries are "recompiled" when importing. This caused at least one query to fail (vmd stuff, due to join not working)
done: cvsEntry_v223p0306_importedAllObj3 --copied SQL from original, still some different, but length of SQL always thte same, so likely just ordering of clauses. Nothing added, nothing removed.
THIS HAD ERRORS in query (SQL changed) and so we need to create a registry of queries and SQL before attempting this.

History

#1 Updated by Michael Lee about 11 years ago

This seems to be fixed when compact and repair is done in Access 2007, which is part of the release process.

#2 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 3180

Also available in: Atom PDF