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!