1

Topic: Whether it is possible to hold a file on duty xml near to the data?

I am sorry for a stupid title of a subject. Now I will explain that I want.
There is a table dataful about weather per every day on various cities.
For statistics it is necessary  a XML document which would contain approximate structure:

<root>
<record id=1>
<city> Kazan </city>
<temp> 22.00 </temp>
<direction> north </direction>
</record>
<record id=100>
<city> Saratov </city>
<temp> 24.00 </temp>
<direction> nord-west </direction>
</record>
...
</root>

Data is updated not so often.
And here requests become regularly. And a trouble that SQL is strained extremely. Then, the server code (application) turns the answer  in , well and  xml. It is prodigal enough operation which bends a server for some minutes.
Tell, whether it is possible on the basis of transient data in a DB to generate means SQL the necessary xml-file, that not  its each time request the code from application?
However, if the data in  underwent changes it also would be reflected on xml (i.e. the node (was added or deleted), the information if for example, temperature adjustment on a specific city has been imported) would change.

2

Re: Whether it is possible to hold a file on duty xml near to the data?

wrote:

Tell, whether it is possible on the basis of transient data in a DB to generate means SQL the necessary xml-file, that not  its each time request the code from application?

Make y with xml a field and in  on insert/update on weather it will do uniform xml document on a city.
A clients will purely read already ready document

3

Re: Whether it is possible to hold a file on duty xml near to the data?

It is possible through sparse if the structure approaches
https://www.sqlskills.com/blogs/paul/sq … olumn_set/

4

Re: Whether it is possible to hold a file on duty xml near to the data?

palladin600 ;
Service the broker possesses the functional necessary to you.
Here almost ready :
https://ajitananthram.wordpress.com/201 … activator/

5

Re: Whether it is possible to hold a file on duty xml near to the data?

palladin600 wrote:

and here requests become regularly. And a trouble that SQL is strained extremely. Then, the server code (application) turns the answer  in , well and  xml. It is prodigal enough operation which bends a server for some minutes.

Matter is not in generation . Actually, no distinction in an output  or normal sampling - is present.
At you the request which this  forms brakes. Understand with it.
Well, or if it is impossible - store nearby beforehand the counted aggregates, and an output in xml do on the basis of them.

6

Re: Whether it is possible to hold a file on duty xml near to the data?

uaggster wrote:

Matter is not in generation . Actually, no distinction in an output  or normal sampling - is present.
At you the request which this  forms brakes. Understand with it.

Selected  from connection to the server on a server it is quickly given.
Business in a wrapper which turns the data in xml-TAGS means. It seems that the code in turn takes record and adds the necessary tag I weed.
Most likely it is necessary to do request by means SQL and to return already in a ready type as xml. Thereby to eliminate from a chain a wrapper the application code.