Best way of searching XML [modified]
-
I have a system which uses dynamic forms generated from XML, it saves the results in XML to a seperate table and combines the two on reload but I need a fast way of searching the XML and looking for suggestions, the data is stored like this: I was thinking of using something like: SELECT * FROM xmldatatable WHERE xmldata LIKE 'value="%%"'; Would this be acceptable? I would imagine it would start to get very slow once the record numbers start increasing? (Using PostgreSQL 8.1)
-
I have a system which uses dynamic forms generated from XML, it saves the results in XML to a seperate table and combines the two on reload but I need a fast way of searching the XML and looking for suggestions, the data is stored like this: I was thinking of using something like: SELECT * FROM xmldatatable WHERE xmldata LIKE 'value="%%"'; Would this be acceptable? I would imagine it would start to get very slow once the record numbers start increasing? (Using PostgreSQL 8.1)