XML query

[Pascal Gauvreau]

We have a knowledge database containing a list of questions (around 200).
In our web application, we diplay only one question at a time.
Now we wanted to cache this list of questions in an Application variable
and would like to know what method would be the most appropriate (performance
wise). We were thinking of building an XML document but are concerned about
how fast are query on XML documents compare to opening a connection to database
and retrieving the question one at a time.

[Russell Jones]

Retrieving the xml document from memory will be faster than retrieving it
from a database. If you're using MSXML, be sure to use the
FreeThreadedDOMDocument object rather than a standard DOMDocument object.
Use the XSLTemplate object to cache any transforms. This combination is very
fast and highly scalable.

Russell Jones
Sr. Web Development Editor
DevX.com

"Pascal Gauvreau" <pascal.gauvreau@hrdc-drhc.gc.ca> wrote in message
news:3a6c6805$1@news.devx.com...
>
> We have a knowledge database containing a list of questions (around 200).
> In our web application, we diplay only one question at a time.
> Now we wanted to cache this list of questions in an Application variable
> and would like to know what method would be the most appropriate
(performance
> wise). We were thinking of building an XML document but are concerned
about
> how fast are query on XML documents compare to opening a connection to
database
> and retrieving the question one at a time.