First off, I am incredibly green when it comes to XML, so please bear with me.
We currently have a product listing in the form of an HTML table, about 3000 rows long! To no surprise this table takes quite a while to load and is very painful to edit.
I have no problem getting the data into XML from an Excel spreadsheet but my question is how realistic/feasible would it be to query this much XML data? In practice, a user would specify search criteria and in turn only the relevant XML records are returned, essentially mimicking a database.
I know that a SQL database would be the best solution but that's on the back burner as a long-term solution. Right now we're just trying to find something that's more efficient than what we've got now.
Any advice anyone may have would be great!