Re: Really slow, painfullu slow asp.net web app

Hi,

Fixed it.

As one might see from above code, I was using DataView's &
DataRowView's to filter the tables (which gets fairly large as it
processes an image).

Don't use DataView's or DRV's (even though documentation stresses them
heavily).
Not saying, never use them, but if you are adding data, large amounts
of it, to tables via/thru DVs, it will bog down.

I moved code to a windows app, just to see if it was ASP.NET related
issue.
But windows app, alos slowed way down (oh, btw, in prototype windows I
was not using tables but rather storing data in arrays, hashtables,
collections, etc. which is why prototype was fast).

End up, in trying one thing after another, creating several (variable
number depending upon how an image is to be processed) seperate tables,
then using table.select methods to find/sort/add and it zips right
along.
Then moved it back to a web app.

With DV method ran it twice overnight ... always bombed out, yet
aspnet_wp.exe still churning away in the background ... 16 hours or so
.... nver finishing, web page ceasing to display, aspnet_wp.exe churning
away ....

By working directly with tables (an array of them) it can process the
image 3 times, essentially, in 3.75 minutes, with no lock up, boom
done.

HTH someone.

Mike

.

Relevant Pages

  • Best approach for downloading .zip files in dot net?
    ... We're in the process of porting an old VB5 application to dot net. ... be a Windows app (not a web app). ... We are constrained to use http or https, ...
    (microsoft.public.dotnet.security)
  • Re: Where does the config file go?
    ... Is this a windows or web app? ... For a windows app, if your application name is myApp.exe, the configuration ... and on build it copies the file out to the output directory ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Need to write web service
    ... I think for my web app I chose ASP.NET Web Site next but perhaps it was Empty Web Site--not sure, but I see ASP.NET Web Service which sounds more like what I want this time. ... Can I write a web service in a windows app? ... Web Services are web applications but they can be used in any .NET ... select Add Web Reference to add a webservice. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to detect textbox or dropdownlist is modified
    ... Is this a Web or Windows app? ... If it's a Web app you can add some client-side scripting if you do not want ... >with the added event to save the record i can find each textbox, ... >> TextChanged event for the TextBoxes and ComboBoxes, ...
    (microsoft.public.dotnet.languages.vb)