Read Xml file hosted on server

Question

0.00/5 (No votes)

See more:

Hello,

I am working on realtime web application. To improve the performace of realtime application i am using xml file insted of Database.The xml file is generated with the help of window service.This service will keep updating xml file. Its working fine but problem occures when you try to access same site on multiple instance.The data is not reflected in real time on every instance,means there is milliseconds/seconds delay to reflect data on every instance. Why this is happening?? I am using following code to read xml file.

DataSet dt_xml = new DataSet();

C#

using (XmlReader SR = XmlReader.Create(@"D:\Test\Debug_20620\Resources\RTFloatData.xml"))
           {
               dt_xml.ReadXml(SR);

           }
           dt = (from DataRow dr in dt_xml.Tables[0].Rows
                 where dr["p_TagID"].ToString() == TID.ToString()
                 select dr).CopyToDataTable();

What can i do,so that it will work fast or data reflect on every instance at a same time..
thanks in advance

Posted 20-Jul-15 23:50pm

Member 11151142

Add a Solution

Comments

Richard Deeming 21-Jul-15 9:04am

Do you have any performance measurements to show that the XML file is faster than a database, or did you just assume that it would be?

How does your code handle the case where you're trying to update the file whilst it's being read, or trying to read the file whilst it's being updated?

Member 11151142 21-Jul-15 10:15am

Actully i want to reduce the continuous Database connectivity from realtime module of web application because my windows service is doing this task. I have also observed the performance by XML file and by Direct DB connectivity. Xml file gives better performace than direct DB connectivity. But This performance is valid for only single instance. If you are try to access it on multiple instances then it gives some delay.In that case DB connectivity performs well.
My windows service is continuously update the xml file and also i have synchronised this file.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Guionardo Furlan · Accepted Answer · 2015-07-21T01:42:00

Rather than use a URL to an XML file, I would create an API that returns XML content in each request.
So instead of your server recreate the XML periodically, it would only make when prompted.
You could do an internal cache control to create the XML only once every X seconds between each API call to prevent overload.

Sorry for my English. I read better than write.