Re: Using SQl to store aspx pages and memory problems

TJS,

Sorry - I made a mistake on my first response I did try to correct the issue.

Thanks for providing some constructive comments - going back to ASP for
these pages is something that I have considered.

By looking at this from another direction - maybe a solution can be provided.

What if I use an external program to return a portion of the HTML text that
is returned the user - I am sure that this configuration is not unusual.
Basically when the aspx page is called it goes and calls an external function
and this returns text formatted in HTML - this can simply sent back to the
client using the write statement.

Just say though that the external program decided that it wanted to embed
some server specific information into its html text - say the server name -
to do this you could embed a <%= %> statement into the HTML. Is there not
anyway of parsing the returned HTML and embedded <%= %> statements to result
in pure html text that is then written to the browser?

This does not sound like an unreasonable thing to do - and from the
perspective of the external program - if this was possible - would add
significantly to the flexibility of the system.

Hopefully this example has made some sense - does this sound possible?

--
matthew


"TJS" wrote:

> first, I didn't call you an idiot, Bob Lehmann did...........
>
>
> second, you can't take a bad approach and make it efficient....
>
>
> third, if the classic asp system works, you could leave it in classic asp
> for that piece. classic and .net can run side by side.
>
>
>
>
>
> "matvdl" <matvdl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:77EF1A4E-63FD-457A-966E-0C82968F2242@xxxxxxxxxxxxxxxx
> > Bob,
> >
> > I will respond to your response - as the designer I won't feel as bad as
> > TJS
> > who basically called me an idiot.
> >
> > There are many reason why I am doing it this way - and I don't believe
> > that
> > they are all stupid.
> >
> > 1. Firstly the system was inherited from asp - in asp this idea caused no
> > problems at all and worked very well - other than the overhead of
> > obtaining
> > the text from SQL server and writing it to disk - it all worked very well.
> >
> > 2. I'm not sure - but the idea of having 10,000 aspx files sitting on the
> > web server does not make sense - and it would not solve my problem
> > anyway -
> > the compiling time would still be there and so would the memory issues.
> >
> > 3. It provides an excellent mix of creating a file that has a combination
> > of data that was only available at the time the file was created and
> > combining it with functionality available at the time it was displayed.
> >
> > So - the ability of me to re-design is not possible or desired - wat I
> > have
> > works very well - except for the problems of memory and speed.
> >
> > This was a good idea in asp - so to say that it is simply stupid when I
> > move
> > to aspx is not an helpful answer and sounds more like a cop-out - what I
> > need
> > is someone willing to understand the reasons for designing it this way and
> > for someone to attempt to answer my questions.
> >
> > For example - I have saved the copy of each invoice I send out to clients
> > as
> > text within a database - this text could have been saved as plain html and
> > forwarded to the client - but I have included a chart within these
> > invoices
> > and this chart is a active x control (chart fx - fully interactive) - for
> > the
> > chart fx control to display correctly it must be served from a server -
> > either aspx or asp page - I also need to load the control with data - so
> > the
> > only way to do this was through an aspx file.
> >
> > NOW - it is not possible to re-create the invoice each time someone wants
> > to
> > view it - much of the data used to create the invoice is not available.
> >
> > Also - the fact that SQL is involved is not the problem - the problem
> > comes
> > about as a result of having 10,000 aspx files and the memory and speed
> > that
> > it takes to display them.
> >
> > So - can anyone help? - can anyone offer some insight into how this can be
> > made more efficient - is it possible to save the compiled code into the
> > server and load this up with the file when it is displayed. This would
> > solve
> > the speed issue.
> >
> > Is it possible to get a page to unload once it has been compiled - this
> > would solve the memory issue.
> >
> > Some constructive answers would be helpful.
> > --
> > matthew
> >
> >
> > "Bob Lehmann" wrote:
> >
> >> This is just such a dumb way to do things. You should just start over,
> >> and
> >> brain the idiot who did this to you.
> >>
> >> Bob Lehmann
> >>
> >> "matvdl" <matvdl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:753E0555-B034-40F7-BD3A-E3EE61600EA0@xxxxxxxxxxxxxxxx
> >> > I have a system that was originally developed in asp - the pages are
> >> > saved
> >> in
> >> > SQL (there are over 10,000 pages) and saved to a temp directory in the
> >> server
> >> > when requested by a client.
> >> >
> >> > I have updated this system and changed the pages that are saved to the
> >> > server as aspx - everything works fine and pages can be served - but
> >> >
> >> > Its not impossible for a single client to request 100 plus pages in one
> >> > session - as each page is requested it is retrieved from SQL saved to
> >> > the
> >> > temp directory and compiled - problems are.
> >> > - Performance is well down on the original asp system - I believe
> >> > that
> >> > this due to the compiling of the pages in asp.net
> >> > - The memory usage of server also goes through the roof - there is a
> >> > considerable increase in memory as each page is loaded
> >> >
> >> > Are there any solutions to these problems??
> >> >
> >> > --
> >> > matthew
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Re: Displaying HTML from memory
    ... IIS is out of the questione and I still don'w want to save HTML ... > you can pass a memory stream. ... > web page, you want to display, as a parameter. ... > read the stream and flush its contents to the HttpRespond.Output stream. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Am I on the right track here?
    ... that happens to be HTML ... | display rectangle for each video in that 4x2 layout, ... | display HTML relative to each rectangle. ... Once the server hands the page to the browser, the server, ...
    (comp.lang.php)
  • Re: Am I on the right track here?
    ... that happens to be HTML ... | display rectangle for each video in that 4x2 layout, ... | display HTML relative to each rectangle. ... Once the server hands the page to the browser, the server, ...
    (comp.lang.php)
  • Re: Display web page in a table
    ... Or if your server supports server site include, ... the include file will be loaded into the container file and served as a single file when the container page is requested at fom the server. ... So you don't need a complet HTML page for that part with all the HTML page tags--just the text and HTML for proper display within the container page. ...
    (microsoft.public.frontpage)
  • Re: Simple HTML User Input and Process Output
    ... > Does anyone have a simple HTML example of a user input of two numbers into ... > a form and the display of the product of the two numbers? ... Then write a form handler in the server side language of your choice to ...
    (alt.html)