Re: Optimising Database Calls

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

"Richard Brown" <richard.ian.brown@xxxxxxxxx> wrote in message
news:1158762356.215592.98810@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Richard Brown wrote:
Martin Eyles wrote:

I have an ASP page that makes a vml/svg graph out of data. In order to
extract all the necessary data I have to perform 68 SQL queries, which
is
unfortunatley a bit slow at the moment.

I don't pretend to know much more about SVG than what I've just googled
for but if it is as described on w3.org "a language for describing
two-dimensional graphics in XML" then can you not find a way to pass in
all necessary variables to your stored from and have it return the xml
necessary?


For the purposes of this graph, the begining and end of each output SVG/VML
code line (which also happens to represent one of the 86 graph lines) can be
thought of as predefined arbitrary text. (If you're interested, I used an
element that is valid in both VML and SVG, and added the headers needed for
both, so that the graph shows in both IE and firefox. However this is not
the likely cause of the slowdown, so it is the next bit that is more
important).

The data I am extracting, which goes between these, can be thought of as a
comma seperated list of x and y coordinates (ie. x1, y1, x2, y2, x3, y3)
where duplicates of y coordinates are not added.


.

Relevant Pages

  • Re: Statistical functions
    ... "Ron Rosenfeld" wrote: ... >>The above is easy to graph and I have automated the process, ... > If you extract the formula from the graph by copying it (after selecting the ... > You can use the LINEST function (by regressing against the same variable raised ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Showing Project Progress
    ... Well,I need to extract the data from Project and show it as a graph which compares the actual work and the Baselined work for a time duration. ... "Mark Durrenberger" wrote: ...
    (microsoft.public.project.pro_and_server)
  • Re: Data format
    ... Well, if the project is to extract the graph data, you could take a look at ... The doppler thingy produces rather simple ESC/P, and you need just to parse ... So printcapture will not run on windows mobility. ...
    (comp.periphs.printers)
  • Re: Need help with formula
    ... that you use INDIRECT to quickly extract the necessary data from all 52 ... the extracts in this summary sheet in empty cols to the right. ... worksheet & im looking for numbers in the other 52 worksheets to match with C5 ...
    (microsoft.public.excel.misc)
  • Re: Statistical functions
    ... >This is a little difficult to explain, but the underlying data is simple, so ... >a 6th Order Polynomial Trend line added to the graph. ... If you extract the formula from the graph by copying it (after selecting the ... You can use the LINEST function (by regressing against the same variable raised ...
    (microsoft.public.excel.worksheet.functions)