Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2010 > BOOK: Stephens' Visual Basic Programming 24-Hour Trainer
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #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
  #2 (permalink)  
Old July 21st, 2014, 04:12 PM
Rod Stephens's Avatar
Wrox Author
Points: 3,166, Level: 23
Points: 3,166, Level: 23 Points: 3,166, Level: 23 Points: 3,166, Level: 23
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jan 2006
Location: , , .
Posts: 647
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!)
  #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.


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 05: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





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.