SQL Server & VB6; Which is best technique?

Hello everybody;

I just want to ask the best technique in server-client database application. I developed just like a teller's client Application (POS).

My current setup:
I have SQL server 2005 as my back-end and Visual Basic 6 as my GUI; SQL 2005 deployed in Windows 2003 which is accessible through Internet (VPN Tunnel)

Although my recent application works perfectly (using ADO) but it suffers connection timeouts, lags & etc because of network connectivity issue... Very slow even we have 512kbps Broadband.
Somebody told me to re-design my system to server side execution...


Which is better? Through Stored Procedure or any technique? Suggestions please...

Thanks in advance guys!

As they say, "It's not the size, it's how you use it."

Ask yourself, do you really need to transfer existing number of records to the client, possibly straining network resources in the process? Are you trying to treat the data as arrays (e.g. select all records then filter) at the client instead of treating them as sets of data (hint: WHERE clause) and minimizing volume of data returned by server?

Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)

There was a discussion here about server/client side yesterday, which you might find useful.