Re: Performance issue when storing large dataset in Session variable - ASP.NET Discussion Boards

sabby200624-Oct-06 1:49

sabby2006

24-Oct-06 1:49

i am inserting into a table from an aspx page and writing all the code in c# i need to rollback a transaction how to do that

please help

Regards

Re: How to rollback a transaction

Sathesh Sakthivel24-Oct-06 1:58

Sathesh Sakthivel

24-Oct-06 1:58

4guys[^]

MSDN[^]

Hope this two articles will be very much helpful regarding the rollback a transaction.

Regards,

Satips.

Re: How to rollback a transaction

sabby200624-Oct-06 3:09

sabby2006

24-Oct-06 3:09

Thanks It was quite a usefull link i managed it from there

Regards

Re: How to rollback a transaction

Sathesh Sakthivel24-Oct-06 3:27

Sathesh Sakthivel

24-Oct-06 3:27

Welcome

Regards,

Satips.

Performance issue when storing large dataset in Session variable

Vinkum24-Oct-06 1:45

Vinkum

24-Oct-06 1:45

Hi,

I have developed webshop application using asp.net 1.1. I'm using
DataGrid in one of the pages of my site. During the page load the
DataGrid will be binded by around 7500 products(rows). At the same time
i'm storing the DataSet object in the Session Variable for later
refinement. I'm using StateServer mode for storeing the session values.

But in my server the W3wp.exe is taking 90 - 100 % CPU
Utlilization. Also my pages are loading very slowly. So afterthat even
if i browse some static pages in my site, then the static pages are
also taking much time to load.

I know that session is making problem because of its size. But i
need the DataSet object for later refinement. This i have tested with
only one user. But i dont know what will happen if 1000 of users access
the site.

My Questions are:

1. So How can i store the large DataSet object in session
variable?
2. Is there anyother way to solve this problem instead of
storing it in the session expect in the database?

If anybody knows the solution please let me know.

Thanks and Regards,
Vinothkumar B

Re: Performance issue when storing large dataset in Session variable

Paddy Boyd24-Oct-06 2:51

Paddy Boyd

24-Oct-06 2:51

Surely you don't need to store the whole thing? Confused | :confused:

You could change the code to only populate the dataset with those bits that you need for the current display and have some other dataset that stores changes, maybe...

Re: Performance issue when storing large dataset in Session variable

Dave Sexton24-Oct-06 3:00

Dave Sexton

24-Oct-06 3:00

Beat me to it! lol

Re: Performance issue when storing large dataset in Session variable

Dave Sexton24-Oct-06 2:59

Dave Sexton

24-Oct-06 2:59

Don't store large amounts of data in a session state variable.

Here's my take on your problem;
Refine your dataset to hold fewer items. Limit it only to that which the client machine has requested. If you save a dataset in the session variable you are in fact creating & saving in memory each time a different browser instance loads that page! Major waste of resources.

If your reasoning behind this is faster load times then rather consider cutting down on the number of items in the dataset when the page loads - noone needs to see all 7500 items at once. It may be more postbacks but it's a more usable page.

You could also look at caching[^] the data, though I still wouldn't recommend caching a dataset with 7500 rows.

I'm assuming you using a basket/shopping cart type thing, write the items that the client has selected to an XML file and store/retrieve that on the client machine when you need to do any processing. Why waste server side resources when you can save it on the client?

As a general rule of thumb when it comes to developing for the web, be cheap with your resources.

character count

Deepak the Cool24-Oct-06 1:42

Deepak the Cool

24-Oct-06 1:42

i want count the number of character in textbox in asp.net.i.e. user enter only 30 character in textbox. and when user enter Character in text box the number of character left in textbox shown in lable i.e. if he/she enter 20 character the lable show character left 10 in lable.

so how can i do this.
if you suggest javascript then plese provide complete code because i know very litter about javascript & how to implement in asp.net.

anuj
Blush | :O

dcjoshi2

Re: character count

Jim Conigliaro24-Oct-06 5:00

Jim Conigliaro

24-Oct-06 5:00

Javascript is the way to go:

<input type="text" onkeyup="countCharacters(this,'remaining',30)" maxlength="30" /><br />
Characters Remaining: <span id="remaining">30</span><br />
<script type="text/javascript"><br />
    function countCharacters(source, outputId, maximum)<br />
    {<br />
        outputElement = document.getElementById(outputId);<br />
        <br />
        if(outputElement)<br />
        {<br />
            var length = source.value.length;<br />
            outputElement.innerText= maximum - length;<br />
        }<br />
        <br />
    <br />
    }<br />
</script>

Jim Conigliaro
jconigliaro@ieee.org
http://www.jimconigliaro.com

asp.net server problem?

bolivar4424-Oct-06 0:33

bolivar44

24-Oct-06 0:33

when there's an error the whole site stops responding and the server needs to be restarted. this doesn't happen on local
when the exception is caugth by "try catch" the site is redirectod to error.aspx, the redirection is succesful but still the server stops responding

Re: asp.net server problem?

Dave Sexton24-Oct-06 2:16

Dave Sexton

24-Oct-06 2:16

What's leading up to the exception? Are you doing intensive processing? Are you disposing of resources that you no longer need?

Re: asp.net server problem?

Paddy Boyd24-Oct-06 2:52

Paddy Boyd

24-Oct-06 2:52

What are you doing in the code on catching the error...?

Re: asp.net server problem?

bolivar4424-Oct-06 7:01

bolivar44

24-Oct-06 7:01

just redirect error.aspx

Re: asp.net server problem?

bolivar4424-Oct-06 7:38

bolivar44

24-Oct-06 7:38

Can that be from any reason excepting runtime(when the code compiling)
İ mean i am not see or use the server i only think that this problem can be happen after an error. When the server restarts my site runs perfectly but after an hour the site downs..
The promlem can not solve from the server side..they said we dont know why it happens..and restarts server for solving problem..
İf we can say the problem based on a error(runtime or compiling)..would it helpfull to set all of my variables to null and again settinng they with their original values after i caught the error.. all of my variables define in a module..

Can this solve the problem..or do you have any suggestion about this problem..why it happens..

Thanks…

Print crystal report in asp.net

seyha23-Oct-06 23:29

seyha

23-Oct-06 23:29

Hi, Can u help me?
I have a problem with printing crystal report in asp.net?
when I write asp.net code using Printertoprinter(0,false,0,0) when I click on print button it work
but after host to web server(local intranet) I want to print again but it has no action

Thank u for your help

b2c site

greekius23-Oct-06 23:26

greekius

23-Oct-06 23:26

i need to code B2C site, but i donna where i have to start.
is there starter kit or any sample project on internet. i found on msdn but all links are picked up :'(

ObjectDataSource Output Parameter

wwwlicious23-Oct-06 22:59

wwwlicious

23-Oct-06 22:59

I've done a bit of searching around but cannot find any examples of someone retrieving an output parameter value after an ObjectDataSource.Insert() when it's invoked in codebehind.

objDS.InsertParameters["Name"].DefaultValue = txtContractorName.Text;
objDS.Insert();

how do I get the value of the parameter objDS.InsertParameter["myID"]....

Is this possible or do I need to create a control/form/profile etc parameter to access my output value?

thanks
s.

-- modified at 6:58 Wednesday 25th October, 2006

Run Website

qtuan23-Oct-06 22:41

qtuan

23-Oct-06 22:41

Hi everybody,

i create a website name Test in VS2005.When i run (ctrl+F5), it work
well.But when i open IE and type localhost/Test/default.aspx, it have
error:

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error
and then click the Refresh button, or try again later

A name was started with an invalid character. Error processing resource

'http://localhost/Test/default.aspx'. Line 1, Pos...

<%@ Page Language="C#" AutoEventWireup="true"

CodeFile="Default.aspx.cs" Inherits="_Default" %>

Anybody know, please help me.

Thank you

Re: Run Website

Dave Sexton23-Oct-06 23:55

Dave Sexton

23-Oct-06 23:55

Have you created a virtual folder in IIS?

Re: Run Website

qtuan24-Oct-06 15:15

qtuan

24-Oct-06 15:15

I already created virtual folder in IIS but it not run.
Thank for your help

sms any where in the world from asp.net?

Tridip Bhattacharjee23-Oct-06 22:39

Tridip Bhattacharjee

23-Oct-06 22:39

suppose i will enter only recipient cell no and my short message and then a sms will be sent to the recipient
whatever is the cell no means i dont know where he is now and who is the service provide.so pls tell how could i
send this type of sms from my asp.net apps.is there any free webservice or library there which can be downloaded.

tbhattacharjee

Re: sms any where in the world from asp.net?

Sathesh Sakthivel23-Oct-06 23:40

Sathesh Sakthivel

23-Oct-06 23:40