>Hi folks...
>
>I'm after some idea of the kind of connection/download speeds I am going to get in the following scenario.
>
>I have an Oracle database connected to a web server. The web server has a DSL type connection i.e. about 255 - 500 K/sec (???). My client software is VFP based and I'm using ADO 2.6. There are only 1000 clients or so, each having a DSL type connection to the web.
>
>What I would like to get some idea of is how fast I'm gonna make a connection, how long should it take me to download a small cursor (3 fields * 200 records max).
>
You have a problem; the total bandwidth available to the server connection is the width of the DSL uplink, spread among all connections. Without considering latency, overhead, SQL process or anything else, if you have 500Kbps uplink speed spread among 100 simultaneous users, the maximum bandwidth available to any given connection is roughly
uplink speed/
# of users bits per second; if you figure about 10bps per character for framing and general packet overhead, you're looking at an effective bandwidth-limited performance around .5KB/sec without considering any of the issues I've excluded. IOW, the DSL connection is a shared resource; regardless of how fast any one connection may be, the server has a capacity limited to a totaql of its uplink speed spread among all connections.
>Thanks in advance.
>
>Pablo