🚀 go-pugleaf

John Fried wrote in message <34993B49.11E3@ipass.net>...

>goes to you-know-where in a hand basket. Their network consultant
>reports very high net traffic when the app does certain operations. My
>suspicion is that record pointer movement from all the required
>relations is the cause. The consultant suggested I convert to SQL as a
>means to reduce net traffic. Most users run Pentiums with 32mb RAM (60%
>Win95 / 40% WFWG).
>
>Before re-writing the app for SQL (assuming it can be done in 5.5a/5.6),
>I would like some assurance that using SQL to access DBF tables in a
>5.5a app will actually result in a significant reduction of net traffic
>for the same conditions.

No, accessing DBFs directly via the BDE with SQL will probably result in
poorer performance. The 'network consultant' may be suggesting a switch to a
server DBMS, e.g. SQL Server. If not, then he doesn't know what he's talking
about <g>.

You should analyze the mentioned 'certain operations' and determine if they
can be optimized within the existing architecture for better performance on
the net, before even thinking about converting to C/S.  I think it unlikely
that a C/S architecture will improve performance.

Heck, maybe the net just needs more bandwidth <g>.
__
Bowen Moursund (TeamB)
bowen.NOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm