How can I improve the performance of populating a DataSet from the XML source?
Use schema. It might be created programmatically (fastest), loaded from separate file or present in the data file. Avoid schema inference. Avoid nested tables, use none-nested relations with surrogate keys. Map columns as attributes. Avoid using many DateTime columns. Consider storing DateTime.Ticks instead.
