Re: Nested Nodes in XML from a table
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 14 Dec 2005 08:36:19 +0000 (UTC)
coosa (coosa76@xxxxxxxxx) writes:
> Well considering that many persons would be accessing a search engine;
> who knows how many of them will be in the future acessing at the same
> time; wouldn't that be pressuring the database engine much?
Maybe. Then again, an implementation of low complexity is always appealing.
Doing things like caching a file, is also a thing that can be saved until
later, when you have the basic functionality going.
> I have thought about the idea due to the fact that accessing XML filles
> is much faster than accessing the actual sql server.
> It's still experimental and i'm totally new in this field.
> But can you at least give me the term name used for such methodolgy you
> mentioned so that i can search for that term and see examples?
The term *is* Query Notification, and I encourage you to read about it
in Books Online. I don't have Books Online 2005 on this machine, so I cannot
give you a direct link. But use the index.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Nested Nodes in XML from a table
- From: coosa
- Re: Nested Nodes in XML from a table
- From: Erland Sommarskog
- Re: Nested Nodes in XML from a table
- From: coosa
- Re: Nested Nodes in XML from a table
- From: Erland Sommarskog
- Re: Nested Nodes in XML from a table
- From: coosa
- Re: Nested Nodes in XML from a table
- From: Erland Sommarskog
- Re: Nested Nodes in XML from a table
- From: coosa
- Re: Nested Nodes in XML from a table
- From: Erland Sommarskog
- Re: Nested Nodes in XML from a table
- From: coosa
- Re: Nested Nodes in XML from a table
- From: Erland Sommarskog
- Re: Nested Nodes in XML from a table
- From: coosa
- Nested Nodes in XML from a table
- Prev by Date: Re: Nested Nodes in XML from a table
- Next by Date: Indexing a View
- Previous by thread: Re: Nested Nodes in XML from a table
- Next by thread: Using muliple smaller SPs and Functions better than using 1 big SP?
- Index(es):
Relevant Pages
|
