Article View: borland.public.vdbase.data.sql
Article #1425Re: SQL vs. VDB or VDB Client / Server
From: Greg Hill
Date: Wed, 22 Oct 1997 00:00
Date: Wed, 22 Oct 1997 00:00
52 lines
2587 bytes
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-mailReferences:
<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