>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
>2.- Direct Private line & Módem Connection @ 55,600 bps
>
>Has anybody experienced the difference if there is one?
>How do the databases work regarding speed if you are not using Ms. SQL server or similar?
>Do you have any ideas about how can I design a remote system without using SQL?
>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
The private line should be more reliable and less subject to line noise.
You will have a speed problem since all the records you are working with will have to travel over the phone line. You can minimize problems by making sure your queries are fully Rushmore optimizable. If they are not all the records will pass over the phone line to see if they belong in the result set, but with Rushmore only the index data must be examined and only the records in the result set will be transfered.
You may want to consider using a product like PC-Anywhere to access the computer running the application. This avoids having to transfer the data over the phone line but you will still experience response problems with screen updates.