This method apples to opening large tables of a quarter million or more rows and will virtually eliminate the initial startup time on the table.
To open large DBMS tables faster:
- Modify the MapInfo_MapCatalog definition to include a new column, NUMBER_ROWS that is an integer column.
- When the count of the number of rows does not change dramatically, run the tool MiRowCnt to determine the row count and store it in the MapInfo_MapCatalog.
PostGIS users can improve how fast large PostGIS tables open by setting the Use Declare/Fetch option in the PostgreSQL Unicode driver's connection properties. For instructions on how to do this, see How do I Open Large PostGIS Tables with an Out of Memory Message.