KS DB Merge Tools logo KS DB Merge Tools
Documentation
AccdbMerge logo for MS Access
aka AccdbMerge
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
KS DB Merge Tools for Cross-DBMS logo

Computer resources

Every computer software consumes computer resources - it occupies some space on disk, it consumes CPU and RAM when it is running. Database connections, reading and query execution may produce database workload and consume network bandwidth. It may be important to know about this stuff, in order to understand what kind of resource consumption is expected.

Internet

All possible internet consumption is described in detail in the Our online services section.

Other network and database connectivity

You may choose to connect to the database located on the network. Database operations are performed each time you read objects, merge objects, compare data, synchronize data, refresh objects or data.

Disk (SSD or HDD)

When you install an application, its binary files are extracted to the folder specified during installation (defaults to "c:\Program Files (x86)\AccdbMerge" for per-machine installation). Application is pretty compact, binary files do not take more than 10 megabytes

In addition to Program Files, application uses the following folders and files:

  • Application settings file, located at "c:\Users\your_profile_folder\AppData\Roaming\AccdbMerge\Pro\Settings.xml". This file holds your license key, recent databases list and other application settings. Please note that manual edit of this file can break application start.
  • Application is using temporary local cache for the following items:
    • Objects processed using SaveAsText/LoadFromText Access application methods
    • Some object definitions (forms, reports, etc.)
    • Data merge/delete temporary logs
    These files are created in the folder configured by the Local Cache parameter on the Misc. tab of the Settings dialog. By default is "c:\Users\your_profile_folder\AppData\Roaming\AccdbMerge\temp" folder. These files have names in format of processId_someGuid.db and automatically removed when this data is no longer needed (for example - data diff tab or merge dialog is closed). In case if an application was closed unexpectedly without appropriate local cache cleanup, additional cleanup happens on the next application run by removing old cache files - whose process id does not belong to any instance of running application.
  • Application error log file, located at "c:\Users\your_profile_folder\AppData\Roaming\AccdbMerge\Pro\AccdbMergeErrorLog.txt". This file is created in case of unexpected error and keeps information about the last such error. That's the same file that you can send us using the 'Unknown Error' dialog.
  • Diff profiles and *.acdms files - these are additional setting files which can be created by the user. User explicitly specifies where these files should be located
  • If report files auto-generation is enabled then report files a created in the folder configured by the corresponding path in the 'Excel reports' parameters on the Misc. tab of the Settings dialog. Auto-generated file names are based on the current timestamp and content being processed.
  • Prior to 1.29.0, AccdbMerge was using system temporary files to process objects handled by LoadFromText/SaveAsText methods of Access application

RAM memory

Part of database object definitions and all object definition diff results are stored in RAM (other part of object definitions is cached on the disk in the local cache folder). Data for all tabs (diff results, object lists, etc) is also located in RAM.

Prior to 1.29.0, all object definitions were stored in RAM and for large amount of heavy forms and reports it could be a pretty big amount of memory for x86 application. If you use these old versions and facing with 'Out of memory' error during objects processing, you need to turn on the 'Enable compression' option on the Text Diff tab of the Settings dialog (available only for Pro).

Last updated: 2024-05-17