🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: SQL vs. VDB or VDB Client / Server

#1624
From: Greg Hill
Date: Sun, 09 Nov 1997 00:00
22 lines
1396 bytes
> What I am saying is I do not have a DBMS. I use DBF tables located on 
>my server. The server is connect through a T1 line with ethernet. I use 
>Local SQL commands in my VDB apps to retrieve data from the server with 
>that type of response.

I hear you loud and clear now, thanks for clarifying that for me.
I will say that I'm surprised of how fast you say it is.  I'm doing some 
experimental stuff on my local hard disk right now using Local SQL and 
it does not seem to be that fast against 8000 records on a 686 120mhz 
cpu 32mb ram.
It might be because I'm not using the right syntax or because I'm not 
using indexes.

--------

>All that is needed is to define a database alias in the BDE

Is this a must?  I've done some testing and did not need to define an 
alias.  Maybe that is why my test was disenchanting?

Thanks again, Greg
Technical Details
Message-ID: <3466A427.F64@n2.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <01bcd473$2448a740$828471cf@greg> <01bce9f4$23198ba0$1030f489@jyuzamas.robins.af.mil> <3460BF14.5C0E@n2.net> <01bcebc6$dc883fe0$1030f489@jyuzamas.robins.af.mil>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e35393e0296adb90
X-Google-Attributes: gidff5a1,public
From: Greg Hill <ghill@n2.net>
Subject: Re: SQL vs. VDB or VDB Client / Server
Date: 1997/11/09
Message-ID: <3466A427.F64@n2.net>
X-Deja-AN: 288364505
References: <01bcd473$2448a740$828471cf@greg> <01bce9f4$23198ba0$1030f489@jyuzamas.robins.af.mil> <3460BF14.5C0E@n2.net> <01bcebc6$dc883fe0$1030f489@jyuzamas.robins.af.mil>
Organization: Serv-U Computers
Newsgroups: borland.public.vdbase.data.sql