Frequently asked questions, Q: how can i improve mapmarker performance, Q: what determines if a row is unmatched – Pitney Bowes MapMarker USA User Manual
Page 293

Appendix C:
Frequently Asked Questions
MapMarker USA 25
293
User Guide
Frequently Asked Questions
Q: I have a table that I cannot geocode because I get the error “Unable to
update row.” What does this mean and how can I fix it?
A: This error occurs when MapMarker attempts to create the point object for a given row and is
unable to do so. To fix this problem, remove the map from the table, and use either MapMarker or
MapInfo Professional to re-create the map file associated with the table.
To use MapInfo Professional to remove the map file association, select Table > Maintenance >
Table Structure from the menu, and clear the “Table is Mappable” check box. This causes the map to
be dropped from the table and all the objects associated with the table to be removed. Alternatively,
you can delete the MAP file associated with the table manually.
After dropping the map, simply open the table with MapMarker and re-geocode the table.
MapMarker automatically makes any table that you open mappable, and you are able to geocode
the table without getting the error.
Note that this error may also result from running out of disk space while geocoding with MapMarker.
Q: I open a table in MapInfo Professional and I am able to open that same
table in MapMarker. Is this safe?
A:
No. Avoid opening tables with MapMarker that are already open in MapInfo Professional.
MapInfo Professional closes files that are not actively being used. Once MapInfo Professional has
closed all the files associated with a table, MapMarker is able to open that same table, potentially
causing a conflict between the two applications.
Q: How can I improve MapMarker performance?
A:
Performance is improved by sorting the table to geocode by ZIP Codes™. You can also improve
performance by requiring an exact match on street names and/or ZIP Codes. Other things you can
do include:
•
Use the fastest processor available to you.
•
Have enough memory so that the operating system can allocate some memory to your disk
cache.
•
Copy the Address Dictionary to your hard drive.
•
Do not create points automatically.
Q: What determines if a row is unmatched?
A:
Unmatched rows are those rows in your table that have a result code that is either blank or
contains an “N”. These are the only rows that MapMarker attempts to match when you choose to
geocode unmatched rows.