Re: Error executing version of Net Framework
- From: stcheng@xxxxxxxxxxxxxxxxxxxx (Steven Cheng[MSFT])
- Date: Fri, 02 Feb 2007 11:52:48 GMT
Thanks for your followup Hermawih,
Based on your description, I think your current concern is that how to
improve the performance when a user select a certain data item in the
Listbox and need to display the description of this item, correct?
Currently, what you've tried is
** postback the page whenever a user select a item in listbox and query the
database and set the queried value to textbox
** still postback the page whenever a user select a certain item in
listbox, but instead of getting description by querying the backend
database, you read the cached DataSet(in server memory) for data,
I'm wondering how much is the size of each record's description? Is it
possible that we embed all the items(of the same country) in page's
response and make it hidden. and when a certain record is selected we use
client-side script to display it in textbox?
Also, for server-side caching, are you using the ASP.NET Cache storage? I
suggest you cache the datatable for records of each country (but set a
expire timeout). Thus, whenever your page postback to query descrption of a
record, you always try looking up the Cache(for the DataTable that mapped
to a certain country). if cache is empty, you query backedn db to fullfil
the cache. for such cache scenario, it will add memory presure of the
server machine, however, we have to make the choice whether we should
improve the response time or memory usage.
Please let me know your opinion or if you have any other questions.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.
.
- Follow-Ups:
- Re: Error executing version of Net Framework
- From: Hermawih
- Re: Error executing version of Net Framework
- References:
- Re: Error executing version of Net Framework
- From: Hermawih
- Re: Error executing version of Net Framework
- Prev by Date: NumericFirstLast gridview
- Next by Date: Re: Deleting rows from an unbound gridview
- Previous by thread: Re: Error executing version of Net Framework
- Next by thread: Re: Error executing version of Net Framework
- Index(es):
Relevant Pages
|