Hi,
How can to improve speed of load XML,
There are any way to assume that the XML is correct and dont invoque the load or that the XML dont verify with the DataBase.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The initial load only happens once so I wouldn't think a speed issue would be too bad, however I'm happy to review this if it's painful.
The slowest part isn't the actual XML processing, but rather querying the database structure.
I can always add attributes to the XML mapping to include column types and sizes, etc however I prefer not to do this as the current method will discover schema mismatch issues and is more independant of the database capabilities.
The schema checking is required at the moment so that SQL parameters can be created with the appropriate provider type.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
How can to improve speed of load XML,
There are any way to assume that the XML is correct and dont invoque the load or that the XML dont verify with the DataBase.
How long does it take?
The initial load only happens once so I wouldn't think a speed issue would be too bad, however I'm happy to review this if it's painful.
The slowest part isn't the actual XML processing, but rather querying the database structure.
I can always add attributes to the XML mapping to include column types and sizes, etc however I prefer not to do this as the current method will discover schema mismatch issues and is more independant of the database capabilities.
The schema checking is required at the moment so that SQL parameters can be created with the appropriate provider type.
Hi.
My xml file have 2350 lines and the time that require is 1 minute.
If I know that the XML is correct, I don't need verify with the database.