Hi there,

I've been using SQLXML 3.0 and SQL Server 2000 to perform inserts and
updates, using updategrams, on a database. I've found the load time
"from cold" has been incredibly slow taking 4 minutes for one of the
schema (does this suggest bugs in my schema?). Looking at that file as
an example it contains 3 linked tables (so a four table relationship in
all). Around 35 elements and attributes (most of which have been
defined as an sql datatype, except for xsd:date types) with key-fields
being defined. There are two separate root elements in it (though one
refs the other) and about three externally defined simple or complex
types.

When the file is cached saving takes a very short time (less than a
second). Which is fine except for the fact that it seems to lose the
cache file and therefore take the full time again. I was wondering if
people knew the conditions of the cache file being discarded and the
file reloaded? I shouldn't have hit the cache limit but I might of
depending of whether the cache is per file (where I have about 12 XSD
files), per root element (where I probably have about 20) or per root
item, including types (where I probably have exceeded the base cache).

So I have a few questions in this, the nature of the cache (I've read
one of the SQL articles about improving performance in template caching
but the templates seem fast). How to improve performance "from cold"
(though this is a less of an issue if I can sort the cache so it rarely
loads the schema from the system) and whether anyone else has
encountered such slow load times or if it is just me.

Thanks,

Gary