Does anyone know what the performance is like for XML tables that could(1)
be fairly significant in size? I'm going to be using SQL Server for our
main server, but we'll have people out in the field with some of the data
and I want to try and avoid setting up SQL Server on all the field computers
and use xml tables to store the data temporarily. Any thoughts?
Thanks,
Kevin
1. - Most of the tables I can think of now wouldn't be more than 2-3k rows
at most, but I want to plan ahead if the database gets bigger.