| Author |
Topic |
|
samrat
Yak Posting Veteran
94 Posts |
 Posted - 2002-08-27 : 06:54:25
|
| Greetings,I have a application Which has a front end in Visual Basic and the Back End in SQL-Server 2000(MSDE). Whenever i start up the application in the non network mode ie ( take it off the network). My initials screen loads up at a normal speed. but as soon as i put the network cable on it takes long to display the initial screens ( the delay is somwehere between 5-7 sec as compared to less then 1 sec in non network environment). Any Idea y it is behaving the way it is ????RegardsSamrat |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-08-27 : 15:52:11
|
| When you say the "initial screen" are you talking about the startup form that you created in Visual Basic? What does that form do? Is there some "startup" code that it's running? Is there something that specifically leads you to believe that this is related to SQL Server?Edited by - ajarnmark on 08/27/2002 15:52:55 |
 |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-08-27 : 15:57:02
|
| Are you making a connecting to the SQL server on this "screen?"Can you post us the connection string (please change the username, password, and ip/machinename when you post!)Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-08-27 : 19:51:31
|
| Greetings,Sorry for not being very specific with my initial question. But here it is. Yes i am making a connection to Sql server in my Initial screen. The general functionality about is to go and retrive all the clients from the database and update the navigation of the system( Navigation is done thru XML and the value is stored in the Clients table) . Attached is the connection string.Provider=SQLOLEDB.1;Initial Catalog=Database1;Data Source=Testserver;Extended Properties="Trusted_Connection=Yes";Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=Testserver;Use Encryption for Data=False;Tag with column collation when possible=FalseThanking in anticipationSamrat |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-08-28 : 09:07:48
|
| Dear members, Can some one please have a look at the issue and lead me in a direction.Thanking in anticipationSamrat |
|
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-08-28 : 09:23:23
|
| it's an obvious answer ... the MSDE database doesn't appear to be local from your connection string ... so you are experience network lag as well as the time it takes to connect to the server - retrieve data - disconnect - then do something with that data .... |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-08-28 : 09:52:21
|
| Well i think the connection string says the MSDE database is local.. RegardsSamrat |
|
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-08-28 : 10:02:37
|
| then why aren't you using the server name LOCALHOST? or 127.0.0.1 |
|
|
|
Onamuji
Aged Yak Warrior
504 Posts |
Posted - 2002-08-28 : 10:18:47
|
| did you ever consider it to be a connection pooling thing ... it may be starting up the first time you connect ... and they do timeout after XX seconds ... so if you run the application again it would have to create the pool again ... thus the delay ... either put in your connection string to keep the connection pool size to one or just accept the delay...or turn off pooling to see if that helps ... in your connection string put "pooling=false;"Edited by - onamuji on 08/28/2002 10:23:45 |
|
|
|
samrat
Yak Posting Veteran
94 Posts |
Posted - 2002-08-28 : 11:04:47
|
| Thank you very much for the reply.. but i think the issue is omething more then that.. as we dont experience any delay on no network mode and very little delay on a network connection with 128K line but a huge delay on 2MB line..and in all the 3 cases it s trying to access the database locallyRegards,SamratEdited by - samrat on 08/28/2002 11:06:00 |
|
|
|
|
Round Trips !!!