Hello everybody,

I'm developing an application with .NET framework and I need fast data
access for read-only use. The data are stored in large XML file (about
80MB and 200,000 entries).

For the best query performance what of the following I must choose?:

1) Use native XML file with XPath query.

2) Export the XML in a database like MySQL. However in this case the
end-user must install the mysql-server locally but this process can be
quite difficult for the final users.

3)Export the XML in MS-Access.

What about you is the best solution?

Thank you!

Kagamoto (AT) gmail (DOT) com wrote:
This is very likely to be slow, but it depends on your queries.

There is a lot of alterntives, such as msde from Microsoft.

Export _to_ Access or export from inside Access to what format?

The ideal solution would be a local XML database supporting XPath
queries, but I am not aware of any, but try asking Google:

http://www.google.dk/search?q=xml+database+xquery

Mvh. Michael.
--
Which is more dangerous? TV guided missiles or TV guided families?
I am less likely to answer usenet postings by anonymous authors.
Visit my home page at http://michael.zedeler.dk/

The best solution would be a custom made one tailored to your needs. An
RDBMs is overkill and unless you plan to share the data with other
XML-capable applications, using XML is also overkill.