Faster SQL connection

[raids51]

is there any way that a vb program can connect to a sql database faster. example: instead of filling a datasource just search right from the server?
I need to do this for my application because i dont want
it to take 5 minutes to startup because its loading the data
Any help would be great!

[Frinavale]

I'm not sure about working directly from databases but have you considered retrieving less data from the database at a given time.?

Eg: retrieve the first 100 records instead of all 32000...then retrieve the next 100 when the are required?

[raids51]

my quick solution

i wanted to load it all at the same time, but i found a easy way out. kinda cheap but instead of the client loading all that data from the server every time it starts, whenever it wants to retrieve information from the database it sends a tcp message to a program on the server which gets the information based on the message, and sends the data back to the client. therefore the client doesnt have to load any data from the DB instead the server loads it all and handles the searches. its not the best way but the loading is faster.

[MrMancunian]

Why don't you just query your database for the right information, instead of either downloading all data into a dataset or using another progam (and thus another errorprone solution)?

Steven