Application Speed

[nancy_padillon]

I don't know where to ask but my code is in vb6 and i'm using sql2000 as my database. The program will be used by users at a very long distance, i've tried to run at one station which is 75km from the Head office, the program is very,very slow. I believed that we already used the best hardware for the application...so what do you think guys?

[gavio]

Physical distance has nothing to do with the speed - or at least you can't (shouldn't) notice the difference...

(please, correct me if i'm wrong)

What exactly do you mean with slow? Slow app, slow queries...?

[nf_vb]

Try to boost your SQLServer in Enterprise Manager:

Select your Instance-Properties-Processor

and check the option - Boost SQLServer Priority on windows

Sometimes helps

[leinad31]

Either find ways to minimize amount of data sent/received (eg. avoid select *), or get better connection (increased bandwidth, less latency, etc).

[si_the_geek]

Moved to Database Development forum

As gavio said, distance by itself is irrelevant - what matters is the speed (and other usage) of the network connection.

The thing to do is to improve your program.. for example, only retrieve/send data that is actually needed (rather than all fields and/or all rows from a table), and use Server Side cursors as much as possible.

For more specific advice, we'll need more information about your program (such as how you connect to and work with the database).

[leinad31]

Also, you and your boss might want to consider converting your VB app to an online implementation (or web application) moreso if your company already has experience with hosting web servers... since asp uses vbscript by default, coding the pages shouldn't be that difficult...