>Hello:
>
>This is killing me because I haven't done it before!
>
>Here in México there are two ways of communicating networks
>
>1.- Dial Up connection with a regular módem & telephone line @ 55,600 bps
Dial-up connections use standard POTS telephone connections; at least in the US, the phone company won't guarenteee throughput on a dial-up line beyond 9600bps. In addition, the X2/KFlex/v.90 protocols are not 56K connections in both directions - it's 33.6Kbps max upload and 56Kbps download with normal retail modems, and unless the connection at the other end is a server modem with a direct digital link at one end, you're going to get a maximum of 33.6Kbps in both directions.
>2.- Direct Private line & Módem Connection @ 55,600 bps
Direct lines are dedicated lines that have line conditioning added to provide guarenteed levels of throughput. The modems used provide 56Kbps throughput bidirectionally. This is a point-to-point arrangement; you don't go through the normal phone system, and can't connect to other lines, obviously.
>
>Has anybody experienced the difference if there is one?
With continuous traffic, the dedicated line will probably give nearly twice the throughput of a dial-up connection because of the maximum data rates ofd the modems. There will be less variation in throughput due to noise conditions as well, and in the US marketplace, the phone company will take steps to guraentee the noise level does not interfere with your data transmission.
>How do the databases work regarding speed if you are not using Ms. SQL server or similar?
If you aren't using server-based transaction processing, then data and indexes must travel over the link. For small data volumes, performance may be acceptable - if you routinely do non-optimized searches, then the entire content of data files may well have to cross the wire, and with large files, that can take quite a while.
>Do you have any ideas about how can I design a remote system without using SQL?
You could try creating a job server of sorts that performs queries for your application and places the results in a table that can be picked uyp after the job is processed, but the time and effort will probably exceed the cost and utility of using a commercial server engine.
>The average MAIN table will be up to 1000 records, and the detail will be about 1,000,000 records some day
>
>Thank you in advance for your ideas + time
>
>Mao