Data loads slowly in client side

Question

1.22/5 (2 votes)

See more:

SQL-Server-2008R2

VS2012

I have a client/server windows application :

Network is local with good speed

server :win server 2012 on hyperV ,sql 2008 (3 table ) and sql user login created for authentication in clients ,no antivirus , firewall off

client :win 7 ,visual studio ,no antivirus ,firewall off

I remote my server (win server) and data loads fast locally but when I work with visual studio in client data loads with latency ! but I have just one record in my table and as I mentioned firewall or antivirus is off.

what's the problem ? should I do something in firewall

Posted 21-Apr-15 7:34am

Nima.naqipoor

Updated 23-Apr-15 17:17pm

v3

Add a Solution

Comments

Kornfeld Eliyahu Peter 21-Apr-15 15:01pm

There are lot of things that can make data load slowly...One of then is your code...You should show us...

Nima.naqipoor 23-Apr-15 1:32am

Tanx but I don't think that's for code,cause I retrieve data from server explorer in vs2013 and use show table data but it's slow !

upendra shahi 22-Apr-15 2:36am

optimize your code..

ShahidRiaz 22-Apr-15 5:03am

Share the code and the query

Nima.naqipoor 23-Apr-15 1:50am

it seems there's something like firewall ...cause in server explorer is slow too

Joan Magnet 22-Apr-15 10:47am

which is the ping response between the client pc and sql server?

are you using pipes or tcp?

Nima.naqipoor 23-Apr-15 1:20am

ping reply time<1ms ttl=128

Nima.naqipoor 23-Apr-15 1:59am

I test the connection in server explorer (modify connection) with sql authentication and it take too long to show succeed connection!

Joan Magnet 23-Apr-15 3:03am

It sounds like a network issue more than an SQL problem.

Nima.naqipoor 23-Apr-15 3:08am

so what test do you suggest?

Joan Magnet 23-Apr-15 3:17am

Take a deep look to the network config. Is this server a virtual machine? Are you using this server for other purposes than SQL?
How fast can you copy a big file between the server and the client?
Can you try it in another server?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)