Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Visual Basic > VB 2010 > BOOK: Stephens' Visual Basic Programming 24-Hour Trainer
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Stephens' Visual Basic Programming 24-Hour Trainer
This is the forum to discuss the Wrox book Stephens' Visual Basic Programming 24-Hour Trainer by Rod Stephens; ISBN: 978-0-470-94335-9
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Stephens' Visual Basic Programming 24-Hour Trainer section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old July 21st, 2014, 01:39 PM
Authorized User
Points: 82, Level: 1
Points: 82, Level: 1 Points: 82, Level: 1 Points: 82, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2014
Posts: 19
Thanks: 4
Thanked 0 Times in 0 Posts
Default Changing data connection slows down the application

Hi, I have a weird situation and I spent couple of days figuring out where the problem is and no luck! Here it is: I created a database application using the entity framework data model (connected to a sql server database on my desktop) and it works perfectly. Now, I am planning to deploy it so other people can use it too, so I changed the data model connection to a database on the server with different credentials. What happened after this change is that everything extremely slowed down. The query from the database itself is not much longer, but the operations on all the controls on my form are way longer (some of them are not even connected to the data model).

Could you please point me to the right direction?

Thanks
Reply With Quote
  #2 (permalink)  
Old July 21st, 2014, 04:12 PM
Rod Stephens's Avatar
Wrox Author
Points: 3,145, Level: 23
Points: 3,145, Level: 23 Points: 3,145, Level: 23 Points: 3,145, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 641
Thanks: 2
Thanked 96 Times in 95 Posts
Default

Sorry but I haven't heard of anything like that happening. Right now you're trying to run the application from your computer but with the remote database, right?

Does it take longer the first time it loads and the performance improves during subsequent operations? That might indicate you're losing a little extra time setting up the connection but after that things are better.

If that's not the case, I would normally suspect network latency. But if you're right that the queries return quickly and it's just the controls, I'm not sure what it could be.

You might need to dig into the automatically-generated EF code to see if it's doing something strange.

Sorry I can't be more help.
__________________
Rod

Rod Stephens, Microsoft MVP

Essential Algorithms: A Practical Approach to Computer Algorithms

(Please post reviews at Amazon or wherever you shop!)
Reply With Quote
  #3 (permalink)  
Old July 22nd, 2014, 11:42 AM
Authorized User
Points: 82, Level: 1
Points: 82, Level: 1 Points: 82, Level: 1 Points: 82, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2014
Posts: 19
Thanks: 4
Thanked 0 Times in 0 Posts
Default

Thanks for your reply. I'll try to look into the EF code and will update it here if I found anything.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing a connection string Patc4 Pro Visual Basic 2005 1 March 29th, 2009 09:00 AM
Visual Studio 2005 slows on loading WebProjects. amitjoshipune ASP.NET 2.0 Basics 1 April 17th, 2008 09:35 PM
CRYSTAL REPORT 9 Changing Connection Properties aquiintac VB Components 0 November 6th, 2007 04:17 AM
changing connection string at runtime kscase VB Databases Basics 2 July 3rd, 2007 10:47 AM
Delete slows down rahzan Access VBA 2 April 11th, 2005 02:19 PM



All times are GMT -4. The time now is 11:08 AM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.