Monday, June 6, 2011

NM Collector Software Version 2.4.0 Much Faster


NM Collector Software Version 2.4.0 now available for download. Large collections will see an order of magnitude improvement in response times with this new release.  The database interface for Version 2.4.0 of NM Collector Software was rewritten to maximize performance.

Here are some results of a performance comparison of Version 2.4.0 with the previous 2.3.1 release.
Notes:
  • Not all possible combinations of  (Computer | Data | Program | Operation) were tested
  • However, performance benchmarking is not yet complete.  As more tests are conducted the results will be posted here.

Observations

In general, overall performance is improved for any size database. However, the bigger the database the bigger the performance improvement. In version 2.3.1 performance degraded exponentially as the database size increased to the point that it became essentially unusable for large databases. In version 2.4.0 performance degrades in a linear fashion resulting in orders of magnitude performance improvements for large databases.

Benchmark Computer Setups

The following two computers were used for benchmarking:

Computer 1:

  • Toshiba Satellite Notebook Computer with AMD Dual Core M300 2 GHz Processor
  • 32 bit Windows 7 Home Premium
  • 3 Gig Memory

Computer 2:

  • HP Pavillion Computer with AMD 64 X2 Dual Core 4200+ 2.20 GHz Processor
  • 64 bit Windows 7 Home Premium
  • 3 Gig Memory

Benchmark Data Setups

The following two databases were used for benchmark testing:

Data 1:

  • Just under 500 items
  • Most with one to four pictures each
  • Pictures stored in the database (not the file system)

Data 2:

  • Just over 150 items
  • None with pictures

Benchmark Program Setups

The program was run under the following conditions:

Program 1:

  • Executed from hard drive

Program 2:

  • Executed from USB flash drive

Benchmark Results

Test Combination
(Computer | Data | Program | Operation)
2.3.1 Times 2.4.0 Times
1 | 1 | 1 | load program 52 minutes 11 seconds
1 | 1 | 1 | close program 31 minutes 23 seconds
1 | 2 | 1 | load program 15 seconds 7 seconds
1 | 2 | 1 | close program 7 seconds 4 seconds
2 | 1 | 1 | load program 50 minutes 20 seconds
2 | 1 | 1 | close program 30 minutes 29 seconds
2 | 1 | 1 | tree indent

2 | 1 | 1 | open report

2 | 2 | 1 | load program 50 seconds 13 seconds
2 | 2 | 1 | close program 9 seconds 6 seconds
2 | 2 | 1 | tree indent 12 seconds 5 seconds
2 | 2 | 1 | open report 15 seconds 8 seconds

Saturday, April 2, 2011

NM Collector Software Version 2.3 now available

 Changes in version 2.3.0 (see complete history of changes here)
  • Clearly marked first field on Identification Tab as the Bar Code field
  • Improvements to Events tab
  • Improvements to Maintenance tab
  • Clean up, reformat, and improve functionality of Collection Types and all List Edits Screens
    • Fixed bug with one insert right after another losing data from previous
    • Fixed issues with data not being saved unless tab was pressed after each entry
  • Improved existing collection types by changing first [Bar Code] field to Unique ID
    • Ammo
    • Home Inventory
    • Whistles
  • Created new collection types for:
    • Licenses
    • Subscriptions
    • Recipes
    • Passwords
  • Created new reports to more easily report out on new collection types:
    • Simple Inventory (all Identification tab fields)
    • Simple Inventory with Notes (all Identification tab fields plus Description tab Notes fields)


For more information please visit:  NM Collector Software JE Collecting Software