Is there a limit to the number of Schemas that can be assigned to an XML Column
Whether it is physical or practical limit.
Schema Collection Limit?
Hot Topic
- question on namespaces
- Unable to install Windows Installer MSP file
- "Server type" is disabled in SQL Server Management Studio
- BOL ABS Overflow error?
- need help designing database
- query distribution using service broker
- How to split out table rows into 3 tables
- MS SQL Server 2005 64 bit CTP:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
- Difference between 2000 and 2005
- Transactions/Client-Side Redirect issue
SQL Server
- Subscriptions and Date Parameters
- YTD - P
- How to use ODBC SQLSetConnectAttr from C# ?
- TableAdapter Not Updating
- the SQL server is Challenging me....:-)
- Query Paging
- Error: Unable to load one or more of the requested types.
- both .net transaction and stored procedure transaction together
- Help with using the right approach
- Can Object Explorer filter on databases?
Schema Collection Limit?
IT wanabe
My situation is this...
In my system I allow customization of the data. These customization are stored in an XML column. It's great that it can be bound by a schema until i start thinking abbout the magnitude.
1000 customers with 100 groups each with a different customization we soon potentially have 100,000 schemas in the collection.
It can get nasty quick.
I think i will need a slightly different architecture.
Thanks
Bill
Rein_21
There is no server limit on the number of schemas. There is a limit on the number of schema components in total (elements, attributes, types, wildcards, facets, etc) of ~2^24. While there is no strict practical limit, the number of schema components you use should fit in memory to get best performance.
mark