I'm having a performance issue with the MissingSchemaAction. the metadata takes some time to get and if we set it to add instead of addwithkey (default) it speeds up alot.
I try to find out what impact it will be if I change the property value from AddWithKey to Add. Where should I not use this!?
I'm only using datatables on a winform program. Devart Version 5.35.79
Related post:
http://www.devart.com/forums/viewtopic. ... hemaaction
MissingSchemaAction
Please refer to http://msdn.microsoft.com/en-us/library ... ction.aspx.
MissingSchemaAction.Add adds the necessary columns to complete the schema.
MissingSchemaAction.AddWithKey adds the necessary columns and primary key information to complete the schema. This ensures that incoming records that match existing records are updated instead of appended.
If you are sure that primary key information is set correctly in your data table, you can use MissingSchemaAction.Add.
MissingSchemaAction.Add adds the necessary columns to complete the schema.
MissingSchemaAction.AddWithKey adds the necessary columns and primary key information to complete the schema. This ensures that incoming records that match existing records are updated instead of appended.
If you are sure that primary key information is set correctly in your data table, you can use MissingSchemaAction.Add.