473,326 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

databased filled dropdown slow or crash

Hello,

I fill a dropdown with data from sql server with vbscript. In the view
on the sql server are just citynames, only one row. To fill the
dropdown takes round about 4 seconds. That's not nice, but if it only
happens on page load, I can live with it. The realy bad thing is the
posback. Either it takes 20 seconds and more, if I do a databind() on
the dropdown, or the hole page crash.

I tested it with dataset and datareader. Both work in the same way.

It have to be possible to fill a dropdwon with a lot of data in a
rather fast way and no problems in with postback (holidaypages can do
this too).

Can some one help me, please.

Nov 19 '05 #1
3 1252
You say you are filling it from the SQL Server using VBSCRIPT ?, Are you
really doing this from the client ?

You should be binding to a DataSet serverside and then saving this to cache
which will be so much faster once the initial page has loaded and really
should not be too slow on load either.
Mr N


"catweezle2010" <ca***********@gmx.de> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
Hello,

I fill a dropdown with data from sql server with vbscript. In the view
on the sql server are just citynames, only one row. To fill the
dropdown takes round about 4 seconds. That's not nice, but if it only
happens on page load, I can live with it. The realy bad thing is the
posback. Either it takes 20 seconds and more, if I do a databind() on
the dropdown, or the hole page crash.

I tested it with dataset and datareader. Both work in the same way.

It have to be possible to fill a dropdwon with a lot of data in a
rather fast way and no problems in with postback (holidaypages can do
this too).

Can some one help me, please.

Nov 19 '05 #2
Hello Mr N,

my mistake. It's not vbscript on clientsite. I just wanted to say I use
vb and not c#.

I do it onpageload. And it is slowly. But on Postback it's the horror.
I think, the postback deliver all the data back to the server, don't
know what he is doing with it, but something. And these two steps need
a long time. I think so, because I have a datagrid, in which I drop
data from a select. And because of a mistake in sqlstring I got all
data and the postback needs rather long too.

So the problem is still there - saving to cache, on client site? Do you
have a link or example-code?

Nov 19 '05 #3
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here

If Not Page.IsPostBack Then

Me.adaptCalls.Fill(Me.DsCalls1)
Me.adaptContacts.Fill(Me.DsContacts1)
Me.adaptContactTypes.Fill(Me.DsContactTypes1)

AddToCache("adaptCalls", adaptCalls)
AddToCache("adaptContacts", adaptContacts)
AddToCache("adaptContactTypes", adaptContactTypes)

AddToCache("dsCalls", DsCalls1)
AddToCache("dsContacts", DsContacts1)
AddToCache("dsContactTypes", DsContactTypes1)
End If
End Sub


"catweezle2010" <ca***********@gmx.de> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...
Hello Mr N,

my mistake. It's not vbscript on clientsite. I just wanted to say I use
vb and not c#.

I do it onpageload. And it is slowly. But on Postback it's the horror.
I think, the postback deliver all the data back to the server, don't
know what he is doing with it, but something. And these two steps need
a long time. I think so, because I have a datagrid, in which I drop
data from a select. And because of a mistake in sqlstring I got all
data and the postback needs rather long too.

So the problem is still there - saving to cache, on client site? Do you
have a link or example-code?

Nov 19 '05 #4

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

Similar topics

0
by: Xiao Li | last post by:
I have an application written in ASP. It only uses JavaScript (.js) on client side. If the browser is accessing the web site through fast connections, like intranet or broadband, everything is...
1
by: pcchong | last post by:
I have 3 websites and make use of free counters provided by other web hosting companies to count the no of hits. Now I want to install a multiple-user databased driven asp counter (with initial...
1
by: Joseph Barron | last post by:
Here is a SIMPLE problem that I'm trying to solve. It works in Netscape 6.2, but IE6 gives ""No such interface supported." Below are page1.htm and page2.htm . In page1.htm, there are two...
10
by: JL | last post by:
Does anyone have any ideas on this please? I don't know how to evaluate the no-blank selections against each other from a form as follows: . I have a form with 6 dropdown fields, each...
2
by: VM | last post by:
When I display data to a Windows datagrid I usually fill the underlying table (in another class) and then, once it contains all the data, I attach it to the grid. But there are some processes that...
3
by: Developerforum | last post by:
Hi, My customer is looking for a web control that allow them to perform speedy data entry. They wanted a dropdown list box which they can also key in the code directly (like a text box). I...
5
by: Gil | last post by:
Is there a way to tell if a combbox is in dropdown mode. I tried and if statement combobox.dropdown = true but i get an error. dropwndown function doesnt store if its true or false what i am...
2
by: Sin Jeong-hun | last post by:
If I create a button like control, then I simply can draw button-like lines on my User Control's surface by getting its Graphics g. If I draw outside of the control's ClientRectangle (for example,...
1
by: anonymoushamster | last post by:
On my dropdown, if I type it automatically goes to a related item that matches what I type - so long as whatever I type takes less then one second. How can I extend this timeout ? (I have...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.