Import speed into TARGIT InMemory Database varies depending on connection type to the source database. Data can be imported via ODBC, OLEDB or Native Dot Net Providers.
In tests, we have found the following to be speeds typical of a Sql Server import:
- ODBC link 20,000records per second
- OleDB 40,000records per second
- Native Dot Net Provider 170,000 records per second