How can I improve the processing speed?
One2OneMileage has been written to take advantage of modern multi-core processors. However, some of this speed depends on a correct configuration. Here are some suggestions for speed:
•Make sure your database has a correctly defined index on the primary key (often called 'UID'). Note that indexes cannot be applied to Excel workbooks. Large datasets should be implemented using a proper relational database using Microsoft Access or via an ODBC connection.
•Try to run the database locally. The database is usually the bottleneck, so make sure all communications to it are fast, and the database is fast.
•Remove duplicate rows from the input data.
•Use a solid state drive (SSD) for the road pack, and the database. The database is the main bottleneck. Most of the road pack is stored in memory, but some of the indexes have to be kept on disk due to their size. A SSD will ensure they are read quickly.
One2OneMileage appears to hang when loading the road pack
As a guide, the largest road pack (contiguous USA) requires 16GB RAM and takes up to 2 minutes to load under normal conditions.
If you have insufficient memory then normally One2OneMileage and/or Windows will give an out-of-memory error. Sometimes Windows does not do this, and will continue to try and use excessive swap. The general effect is that your PC will slowly grind to a halt. Technically it has not run out of memory, but for all intents and purposes it has. Try a PC with more memory or use a smaller road pack.
One2OneMileage does not recognize the Excel columns that store my location names
This usually occurs if your location names are numbers. Location names are often numbers if you are using your own numeric identifiers, or if you are using zipcodes. Excel is weakly-typed and will usually treat these as numbers. However, the locations must be text for One2OneMileage to recognize them properly.
It is strongly recommended that you use use a proper strongly-typed database (e.g. Access or an ODBC connection) for applications like this. However, if you must use Excel, format the entire column as text and precede each and every value with a quote (') character. The quote character tells Excel that the field is text and not a number. An alternative is to use text location names.
I cannot open my Excel workbook or Access database when One2OneMileage is loaded
This is a side-effect of the Office drivers. You may have to exit One2OneMileage in order to view the workbook or database. The solution is to switch to a proper relational database such as SQL Server.
One2OneMileage opens a table but cannot see any/all of the columns
One2OneMileage must have read/write access to both the table and the columns. This is also true for the location columns. The only exception is the primary key column, which can be read-only.