🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: SQL vs. VDB or VDB Client / Server

#1425
From: Greg Hill
Date: Wed, 22 Oct 1997 00:00
52 lines
2587 bytes
Brian Evans wrote:
> 
> Greg Hill wrote:
> >  [stuff removed]
> > I keep hearing this SQL stuff.  Things like it brings down the amount of
> > traffic across the wire, it is network aware you make a request and the
> > work is done at the Server using the servers memory/cpu and when it is done
> > it sends back only the requested  information.
> >  [more stuff removed]
> > Any suggestions appreciated.
> > Thanks, Greg
> 
> You are realy considering a database server - most/all of which use SQL
> statements to transfer data both ways. The server would do a lot of the
> work and reduce the bandwidth required.
> 
> It reduces bandwith mainly becuase the server has local fast access to
> the database tables and indexes and only transmits what you request.
> If you access the .dbf/.mdx/.dbt files over the network with a slow link
> then it has to transfer the index data, table data that doesn't match
> your current view etc etc.
> 
> The only problem is most database servers are $$$ and charge a
> hefty per seat licence fee ($400-600/seat) which makes it costly
> for small database apps lots of people use. If you will be using
> lots of applications off the database server then it's not bad.
> 
> A server will solve bandwidth probelms but may be overkill in
> other areas.
> 
> Brian

---------
> You are realy considering a database server - most/all of which use SQL
> statements to transfer data both ways. The server would do a lot of the
> work and reduce the bandwidth required.---------

Yes, I agree now that I've done a little research and understand what a 
database server is.  SQL is the database/file format that is setup with 
the database server along with lots 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: <344E36A0.1FE7@n2.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bcd473$2448a740$828471cf@greg> <343DD21C.819@sympatico.ca>

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: <344E36A0.1FE7@n2.net>
X-Deja-AN: 282608199
References: <01bcd473$2448a740$828471cf@greg> <343DD21C.819@sympatico.ca>
Organization: Serv-U Computers
Newsgroups: borland.public.vdbase.data.sql