🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1426

Re: SQL vs. VDB or VDB Client / Server

#1426
From: Greg Hill
Date: Wed, 22 Oct 1997 00:00
72 lines
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-mail
References: <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