|
Example FastLoad: Do you have such a task, dumping millions of records into a table? If you use MS SQL Server as your backend DBMS, you should use this example to load your data into your server as fast as possible. However, this method is specific to MS SQL Server only. For other servers, you should try to use a CBatchParam<T> object instead, as shown in the example MultiProcs. If your provider doesn't support the property DBPROP_MULTIPLEPARAMSETS either, you may consider other ways. This example demonstrates how to insert records into a table using SQL Server Batch CoPy (BCP) utility at the fastest speed. Finally, you can't use the BCP utility with MS data link object. It also implies that you must disable various data services before using this utility. |