🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Planning for future upsizing to SQL

#705
From: Wes Tatters
Date: Sun, 16 Aug 1998 00:00
21 lines
1290 bytes
The application we plan to develop using VdB will initially be
targeted as .dbf tables - for single user versions.   However,
it is planned that for multiuser systems a SQL server will be
used.

Is there any web site or information in existance that details
planning requrements to ensure the best performance under bother
upsided SQL and standalone (local SQL) implementations.  

ie. Appropriateness of next(), prev(), top() etc.
    Use of lookup queries
    Performance issues 
    Indexing issues - local / remote

Also is there any information available about performance issues
relating to multiuser access to dbf tables across a network. 

========================]
[wtatters@world.net     ]
[wtatters@email.msn.com ]
[Brisbane - Australia   ]
Technical Details
Message-ID: <35d79fd7.934869@forums.inprise.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5d82895762015d72,start
X-Google-Attributes: gidff5a1,public
From: wtatters@email.msn.com (Wes Tatters)
Subject: Planning for future upsizing to SQL
Date: 1998/08/16
Message-ID: <35d79fd7.934869@forums.inprise.com>
X-Deja-AN: 381640650
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: Syncomedia Australia
Mime-Version: 1.0
Reply-To: wtatters@email.msn.com
Newsgroups: borland.public.vdbase.data.sql