I have a simple VB program that searches a simple table in SQL server 2000. It has approx 30,000 records and I am looking for a record based on an indexed field. it works fine and fairly quickly. My question is:
If I were to export the table data to an xml file. Are there any tools/programs that could query the data quicker in xml than in sql?
Thanks
If I were to export the table data to an xml file. Are there any tools/programs that could query the data quicker in xml than in sql?
Thanks