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