Quite true, Such an application will work along the 256kb line but from previous experience access will be rather slow; especially is you have 15 or so users on the remote site. Correct me if im wrong but mssql has a lot of "wasteful" communication between the client and the server. You might want to keep a separate database in the remote site and then somehow write out some code to "merge" the two every so often with some thin protocol.
Another way to get over this is to move over to mysql or any other low bandwidth friendly database engine. This might need considerable reprogramming but if you are going to have several offices far away from each other it might be a choise you want to consider. You could also think of making your client applications thin client where they connect via tcp to an application server which in turn communicates with the database. hope that sheds some light - for more email me J -----Original Message----- From: Allan Smith <[EMAIL PROTECTED]> To: [email protected] Date: Sat, 18 Feb 2006 11:00:30 +0000 Subject: Re: [delphi-en] C/s Application on DSL Dataonly Line > On Sat, 18 Feb 2006 08:53:29 +0000 (GMT), Dawood Nisha wrote: > > >Hi , > > > > I have an application build on Delphi 7 / MSSqlServer (ADO) with > around 50 users working under same roof without any problem. We have a > factory and Branch office which is located approx 50 and 600Kms away > from our main office. Now i want to connect our factory and branches > with our mainoffice thru 256Kbps DSL Dataonly line VPN . My question > is whether i have to do any change in my program or it will be just > like adding an additional user in our mainoffice. If i have do any > changes please throw some light on areas where i have to change. Any > URLS related to this subject is verymuch appreciated. > > nisha, > > The main problem I see is that your user at the remote sites will have > slow > access to the data. 256Kbps is about 30 seconds per Megabyte. You may > want to > take action so as to limit or reduce the volume of data that the remote > sites > need to access from you main site. I would have thought that a > client/server > model would help in this respect as you could filter the data at the > main site > and only send a limited amount to the remote site. This may not have > the same > benefits at you main site as the increase in workload for the server > may > outweigh the benefits of reduced network traffic. > -- > Regards, > Allan JM Smith > (Northwood, Middlesex, England) > > > ----------------------------------------------------- > Home page: http://groups.yahoo.com/group/delphi-en/ > To unsubscribe: [EMAIL PROTECTED] > Yahoo! Groups Links > > > > > > ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
