the best way of a connection query
hi,
i working with a sql server 2000 and vb6 and i need a connection/string query to connect from some pc´s in network i have a query but i think that is not the best query because the app freeze for 2segunds when i save/load some data
thanks for your help
Re: the best way of a connection query
So, what is it that you don't know?
- How to connect to your SQL Server database
- or how to write some sql statement
- or both?
:confused: :confused: :confused:
Re: the best way of a connection query
hi,
i know both the app is already running by some time my question is if there is some best way to connect to the server for fast response/performance etc
there is obdc etc etc and i have use some apps that work with a sql server bd and they are more faster than my app.
so i think there is some best way and my question is that what ways you use to improve the operation?
thanks :)
Re: the best way of a connection query
There are about 50 answers to your question, most of them being more questions. I think you should start at the begining and tell us what you have already.
The database you are connecting to is on a lan?
How many records you are bringing back, and how (show the query).
What are the tables setup like (do you have indexing?).
Re: the best way of a connection query
There are various things we could suggest to improve the performance but first we need to know what you currently have. It would help if you could post the code which you deem is running slow. And what provider are you using to access your database?
Re: the best way of a connection query
This thread should really be moved to db forum.
Re: the best way of a connection query
Agreed, and now that I've spotted it, thread moved to Database Development forum