wiki:CodeSnippets/TestBatchInsertion

Version 1 (modified by jng, 15 years ago) ( diff )

--

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;
  }

Note: See TracWiki for help on using the wiki.