Article View: borland.public.vdbase.data.sql
Article #1426Re: SQL vs. VDB or VDB Client / Server
From: Greg Hill
Date: Wed, 22 Oct 1997 00:00
Date: Wed, 22 Oct 1997 00:00
72 lines
3142 bytes
3142 bytes
Mike Trout wrote: > > > I'm getting ready to set up a wan connection between two offices, I'm > not > > sure how much band width I'm going to buy yet but I'm guessing around > > 64mbs. I just did some testing using Visual dBASE 5.5 across a dial > up > > 64mbs???!!!! That's faster than a T-3 line... and 6 times faster than > Ethernet! > > <snip> > > Should I be considering SQL and if I do how could it help if my app > demands > > constant refreshes. > > That's a possibility, but like Gary says, it's going to cost lots of $. > > > If I face the reality of my situation, I think I'm up for a rewrite > on this > > app I think I would have to write something that would download the > data to > > the local PC and keep synchronizing it at certain breaking points > during > > the day. Which means the end-users and the Boss who wants dynamic > reports > > will be a little disappointed. > > I think one of the reasons they wanted to put this WAN up is so > that > > they did not have to pull separate reports and dial up other > locations to > > get reports, they wanted reports that reflected all offices. Later > they > > will be adding another location so the demand is there for a WAN. > > How about PCanywhere? Response is a _little_ slower than really being > there at 28.8k, but definitely liveable because the local PC does the > work, the remote one just displays the screen. > -- > Mike Trout > Nobart, Inc. / Ambrosi & Assoc., Inc. > email address is bot-bait. Replace with miket@... > Have a day :-| --- > How about PCanywhere? Response is a _little_ slower than really being > there at 28.8k, but definitely liveable because the local PC does the > work, the remote one just displays the screen. I'm useing pcANYWHERE for remote support currently and do not see how that would work in a multiuser setup. Both offices would have at least 3 or 4 users in each location attached to the tables at the same time and need to see the updates each others updating instantly. ------- I've done a little research and have a better understand of what a Client/Server, Database Servers and SQL. SQL is the database/file format that is setup with the database server along with of other things as far as configuration goes. I also know now that I could use VDB as the front end or VDB SQL or any language that includes SQL commands. Now I wonder how hard is it to set up the database server. How hard will it be to convert my current code to use SQL or should I say understand SQL command syntax. Yes 64mbs was not what I meant!<g> 64k is correct. Thanks very much for your help. Greg
Technical Details
Message-ID:
<344E38F1.4701@n2.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<01bcd473$2448a740$828471cf@greg> <01bcd589$3dbf14e0$fa0a5a0a@miket.ais.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,f706ce8ff3602deb X-Google-Attributes: gidff5a1,public From: Greg Hill <ghill@n2.net> Subject: Re: SQL vs. VDB or VDB Client / Server Date: 1997/10/22 Message-ID: <344E38F1.4701@n2.net> X-Deja-AN: 282608204 References: <01bcd473$2448a740$828471cf@greg> <01bcd589$3dbf14e0$fa0a5a0a@miket.ais.net> Organization: Serv-U Computers Newsgroups: borland.public.vdbase.data.sql