VB/SQL Implementation over a WAN 1

[nickbhogal]

Hello

My organisation has recently moved a VB/SQL server database from a LAN to a WAN operating over a 256Kbs Frame Relay Network. The system has suffered from poor performance anbd a packet analyser has shown the VB Frontoffice application to pull large data packets across the network.

Can anyone shed light on efficeient design of a VB/SQL server implementation where the SQL server is located across the WAN ?

Regards

Nick

 

[CybOrg]

It's difficult to be specific without knowing the details, but generally speaking you should evaluate the following:

1) Do you use dynasets rather than snapshots for read-only data? This means you're also carrying the overhead associated with updateability.
2) Do you use transactions? Transactions will limit the amount of data transferred over the WAN, since actual DB updates aren't done until the COMMITTRANS. If your app does many updates, try collecting a number of them and the commit them 'en masse' - say every 100 or 10 or 1000 or so.

/Cy