473,473 Members | 2,036 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

DropDown and Caching

JJ
If I were to use Caching for a dropdownlist can I disable viewstate for
this control? Would I lose control behavior like selectedIndex etc.? I
would think since my ddl has like 50+ rows in it and they don't change
once the ddl is populated that this control would be an ideal candidate
for Caching, agreed?

Thanks,

JJ

Sep 4 '06 #1
2 1105
"JJ" <jj****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
If I were to use Caching for a dropdownlist can I disable viewstate for
this control? Would I lose control behavior like selectedIndex etc.?
I would think so...
I would think since my ddl has like 50+ rows in it and they don't change
once the ddl is populated that this control would be an ideal candidate
for Caching, agreed?
If the underlying data never changes or, at least, changes *very*
infrequently, you will gain some (but probably not very much) performance by
caching the DataSource. I quite often do this for static or almost static
data, e.g. countries and currencies - saves a database query every time the
underlying data is required.
Sep 5 '06 #2
Use ODBC its easier.

Mark Rae wrote:
"JJ" <jj****@hotmail.comwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
If I were to use Caching for a dropdownlist can I disable viewstate for
this control? Would I lose control behavior like selectedIndex etc.?

I would think so...
I would think since my ddl has like 50+ rows in it and they don't change
once the ddl is populated that this control would be an ideal candidate
for Caching, agreed?

If the underlying data never changes or, at least, changes *very*
infrequently, you will gain some (but probably not very much) performance by
caching the DataSource. I quite often do this for static or almost static
data, e.g. countries and currencies - saves a database query every time the
underlying data is required.
Sep 5 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Troy Simpson | last post by:
Hi, I have a website which is made up of dynamic pages. Each page that's loaded has some code which looks at which template to load amongst other things, which causes the page to take a little...
1
by: oj | last post by:
Could anyone provide some approaches that are used to cache dropdown list control values to share globally beteween all users? Currently, each time a page is loaded all the dropdown values for each...
5
by: Raj | last post by:
What is the purpose of file system caching while creating a tablespace? Memory on the test server gets used up pretty quickly after a user executes a complex query(database is already activated),...
1
by: Oleg | last post by:
Hi, I'm having a problem with page caching and therefore reusing dropdown box contents. Scenerio: user1 has security to see list of three items(.aspx populates it with three items only) in...
2
by: Lair | last post by:
I am creating a page that has three to four databound dropdown lists. Each one is has different data sometimes from the same table but with a different where clause. What is the best way to...
2
by: George1776 | last post by:
All, I've recently upgraded our production ASP.NET/C# application from framework 1.1 to 2.0. Since then I've been plagued by out-of-memory errors and problems with the cache object (which may...
0
by: jason | last post by:
hi experts, support.microsoft.com/kb/917072 and http://msdn.microsoft.com/msdnmag/issues/06/07/WebAppFollies/ As pointed out in these articles, users might get session variables belong to...
4
by: Hermann | last post by:
My site is a bit slow showing the main page so I thought caching query result in PHP will improve performace. Then I read MySQL documentation and saw that MySQL does have a caching feature. So......
0
by: Shaileshsharma | last post by:
Hi, I am facing a problem from last few dayes.I have a Dropdownleast box which is bind with Table DrugMaster which contain around 65 Thausand Drug. When we use Selected index Change to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.