473,386 Members | 1,841 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,386 software developers and data experts.

vb.net/sql server speed issue

I have a vb.net application running with sql server...
All calls to the database are hit and drop.... i keep no
connections open.... there are two timers in the
application that hit the database to check for new/changed
information (small hits)... here is the problem...

this one has be whipped... please help if you can...

I have only about 80 to 100 users peak... on mondays and
fridays my users are less and the application runs fine
but tuesday-thursday my app will run fast as lightning
unit about 10:00am when the user counts go from 50-60 to
80-100 and then BAM the entire application on all clients
machines come to a screeching halt... and will remain that
way until a few (5-7) users exit the application.... then
the speed will go back to light speed... Also... it
appears that on the first day after putting the database
on a new server it screams regardless of the number of
users... but on day 2 the problem comes back... I have
actually had this thing running in the past on a MSDE sql
server with the same results... DB, Connections, my
App?????? What the heck is going on help help help...
Chandler Dickinson
Nov 20 '05 #1
4 940
Hi Chander,

This is more a language group who does of course also AdoNet, however this
is more the behaviour of that AdoNet.

A very good newgroup for that is
Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>

I hope this helps?

Cor
Nov 20 '05 #2
Hi Chander,

This is more a language group who does of course also AdoNet, however this
is more the behaviour of that AdoNet.

A very good newgroup for that is
Adonet
<news://msnews.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<http://communities2.microsoft.com/co...s/?dg=microsof
t.public.dotnet.framework.adonet>

I hope this helps?

Cor
Nov 20 '05 #3
thanks... i post this question in that group as well... but i am thinking
that this issue may not be related to the data calls....?????
Nov 20 '05 #4
thanks... i post this question in that group as well... but i am thinking
that this issue may not be related to the data calls....?????
Nov 20 '05 #5

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

Similar topics

4
by: David Walker | last post by:
Hi again As I'm developing my site, i've come across a problem with the database use. While developing it I only have mySQL, but the final server has msSQL. I was thinking about using all my own...
67
by: Mike MacSween | last post by:
I've got a SQL Server database. Nearly finished. It's going to go on a single non networked machine. One day somebody might get access to it over ADSL (probably TS), but for now it's a single user...
0
by: Chandler Dickinson | last post by:
I have a vb.net application running with sql server... All calls to the database are hit and drop.... i keep no connections open.... there are two timers in the application that hit the database...
6
by: Ham | last post by:
Yeah, Gotto work with my VB.Net graphic application for days, do any possible type of code optimization, check for unhandled errors and finally come up with sth that can't process 2D graphics and...
1
by: Alexandre (www.pointnetsolutions.com) | last post by:
I am looking at building a distributed system, and i have been looking at many different options, in some cases i was thinking of a client server relation where a client would send a string to...
4
by: rdemyan via AccessMonster.com | last post by:
My application is calculation intensive and the servers are agonizingly slow. Administrators of my application only update the backends once a month (twice a month max). So, my launching program...
39
by: cj | last post by:
I have a 2005 TCP/IP server that creates a new thread to handle each incoming TCP/IP request. Once the request has been answered by the thread the TCP/IP socket is disconnected and the sub/thread...
7
by: Michel Couche | last post by:
Hello, I am working on a project for a potential customer. The project will basically involve an ASP.Net 2.0 application and a database (ideally MS SQL). The customer has already a hosting...
1
by: Jean-Paul Calderone | last post by:
On Fri, 21 Nov 2008 00:20:49 -0200, Gabriel Genellina <gagsl-py2@yahoo.com.arwrote: If you want to try this program out on POSIX, make sure you change the time.clock() calls to time.time() calls...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have 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,...

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.