473,320 Members | 1,829 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Optimizing searches in readonly XML

Hi,

I try to optimize a high loaded site ... the site needs to store in memory,
a 400 tags XML that will be queried many times by many users (it have some
biz rules)...
I wonder if exists something like "compiled XML" or "binary XML" and clases
in dotnet that optimize this queries by time and resources...
Thx in advance.

Sebastian Melgin
Dec 21 '05 #1
4 1039
Melgin wrote:
I try to optimize a high loaded site ... the site needs to store in memory,
a 400 tags XML that will be queried many times by many users (it have some
biz rules)...
I wonder if exists something like "compiled XML" or "binary XML" and clases
in dotnet that optimize this queries by time and resources...


The simplest solution is to load XML into XPathDocument (wghich is
read-only, but takes in average 30% less memory), index it using
IndexingXPathNavigator and query using key() function. Take a look at
"XML Indexing Part 1: XML IDs, XSLT Keys and IndexingXPathNavigator"
article at
http://msdn.microsoft.com/library/en...MLindexing.asp

--
Oleg Tkachenko [XML MVP, MCAD]
http://www.XmlLab.Net | http://www.XLinq.Net | http://blog.tkachenko.com
Dec 22 '05 #2
But does it work in 1.1 version of .NET ?
If not, what can I do ?
Thx in advance.
Sebastian.

"Oleg Tkachenko [MVP]" <so**@body.com> escribió en el mensaje
news:eQ**************@TK2MSFTNGP09.phx.gbl...
Melgin wrote:
I try to optimize a high loaded site ... the site needs to store in
memory, a 400 tags XML that will be queried many times by many users (it
have some biz rules)...
I wonder if exists something like "compiled XML" or "binary XML" and
clases in dotnet that optimize this queries by time and resources...


The simplest solution is to load XML into XPathDocument (wghich is
read-only, but takes in average 30% less memory), index it using
IndexingXPathNavigator and query using key() function. Take a look at "XML
Indexing Part 1: XML IDs, XSLT Keys and IndexingXPathNavigator" article at
http://msdn.microsoft.com/library/en...MLindexing.asp

--
Oleg Tkachenko [XML MVP, MCAD]
http://www.XmlLab.Net | http://www.XLinq.Net | http://blog.tkachenko.com

Dec 22 '05 #3
Hello!

The XPathDocument is still faster than the XmlDocument in this respect, as
it has been optimized for read-only operations (that can be cached).

--
With regards
Anders Borum / SphereWorks
Microsoft Certified Professional (.NET MCP)
Dec 22 '05 #4
Yes, sure it works with .NET 1.1.
IndexingXPathNavigator is part of Mvp.Xml library now, just download
appropriate Mvp.Xml lib version at
http://sourceforge.net/project/showf...roup_id=102352

--
Oleg Tkachenko [XML MVP, MCAD]
http://www.XmlLab.Net | http://www.XLinq.Net | http://blog.tkachenko.com

Melgin wrote:
But does it work in 1.1 version of .NET ?
If not, what can I do ?
Thx in advance.
Sebastian.

"Oleg Tkachenko [MVP]" <so**@body.com> escribió en el mensaje
news:eQ**************@TK2MSFTNGP09.phx.gbl...
Melgin wrote:

I try to optimize a high loaded site ... the site needs to store in
memory, a 400 tags XML that will be queried many times by many users (it
have some biz rules)...
I wonder if exists something like "compiled XML" or "binary XML" and
clases in dotnet that optimize this queries by time and resources...


The simplest solution is to load XML into XPathDocument (wghich is
read-only, but takes in average 30% less memory), index it using
IndexingXPathNavigator and query using key() function. Take a look at "XML
Indexing Part 1: XML IDs, XSLT Keys and IndexingXPathNavigator" article at
http://msdn.microsoft.com/library/en...MLindexing.asp

--
Oleg Tkachenko [XML MVP, MCAD]
http://www.XmlLab.Net | http://www.XLinq.Net | http://blog.tkachenko.com


Dec 25 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Darshak Shah | last post by:
Hi, * Question background : My DB is in ArchiveLog mode. I have TS in ReadOnly mode. As i know, - Oracle allows to DROP table resides in ReadOnly TS (& other objects also) even though that...
4
by: harry | last post by:
<input type="text" name="actreqto" maxlength="20" value="" onkeypress="changedDetails();" onchange="changedDetails();" readonly="readonly"> Any ideas why doesn't this work? ...
3
by: Matt | last post by:
I want to know if readOnly attribute doesn't work for drop down list? If I try disabled attribute, it works fine for drop down list. When I try text box, it works fine for both disabled and...
6
by: Mel | last post by:
I have a large collection of custom objects, each representing a period in time with each having a start datetime and an end datetime. I frequently need to query this collection to return a subset...
2
by: Brian | last post by:
In particular, this question goes out to the Microsoft C++ development team. Back in June, Ronald Laeremans posted the following message. Has the optimizing compiler been included with the...
4
by: Flashman | last post by:
A little confusing with setting up optimizing options with 2003 .NET. Under the Optimization Tab. if you set to /O1 or /O2 is the program ignoring the settings for Inline Function expansion,...
3
by: Michael SL | last post by:
I have a text area in which I have a client side javascript to process a "onclick". Because it is client side, I used a HtmlTextArea <TextArea id="Summary" onmouseup="SumMouseUp()" style="WIDTH:...
8
by: DQ dont quit | last post by:
I'm currently working on a ASP.Net / C# / SQL 2000 project that involves the entering of keywords, that a web user enters, and then searching MSWord documents for those words. This information...
5
by: rkershberg | last post by:
I have two tables. One has approx 90,000 rows with a field .. let's call in BigInt (and it is defined as a bigint data type). I have a reference table, with approx 10,000,000 rows. In this...
10
by: sunil | last post by:
Hello, I am new to c# . I have some basic programming doubts. Please help me in clarifying these doubts. I want to initialize a static and readonly field with a value returned by a static...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.