wiki:CodeSnippets/TestBatchInsertion

This page is an FDO Code Snippet. Visit the CodeSnippets page to view more!

Testing support for batch insert

Using a batched IInsert is a more efficent method of bulk feature insertion instead of using a regular IInsert. For providers like KingOracle?, batched inserts can be up to 10x faster than regular inserts.

Unfortunately there is currently no capability API to determine if a given provider supports batch insertion. The best (albeit hacky) way to determine if using a batched insert is possible is to check if the BatchParameterValues property is null or not.

C# Example

  static bool SupportsBatchInsertion(IInsert insertCmd)
  {
      return insertCmd.BatchParameterValues != null;
  }

Last modified 9 years ago Last modified on Oct 29, 2008 7:34:41 AM