
Download \| Buy It Now!	Sample Screen Shots	Import Data from Old Software
Support \| Help Desk	Collection Templates	Upgrade to Version 2.5.4
User Manual \| Quick Start Guide	Reports
Please Review and Comment	License Agreement

NM Collector Software version 2.4.0 Performance Benchmark

The database interface for Version 2.4.0 of NM collector Software was rewritten to maximize performance. This page presents the 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
2 \| 2 \| 2 \| load program
2 \| 2 \| 2 \| close program
2 \| 2 \| 2 \| tree indent
2 \| 2 \| 2 \| open report

Last Revised: June 5, 2011