Use queries or tables for lookup datasets?

Article View: borland.public.cppbuilder.database.multi-tier

Article #1714

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1714

From: Steve Pietrykoski
Date: Mon, 24 May 1999 00:00

9 lines
885 bytes

Hello all again,

Which type of dataset (query or table) is more efficient for using as a
lookup dataset in the client piece of a multi-tier app?  For small sets
of data, I can cache the lookups, but for large sets this is obviously
not a reasonable approach.  Any experience you wish to share would be
appreciated.

Steve Pietrykoski

Technical Details

Message-ID: <374982C4.860F3328@artisansoftware.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: fcd2b,bb24b8491510d447,start
X-Google-Attributes: gidfcd2b,public
From: Steve Pietrykoski <steve@artisansoftware.com>
Subject: Use queries or tables for lookup datasets?
Date: 1999/05/24
Message-ID: <374982C4.860F3328@artisansoftware.com>
X-Deja-AN: 481561091
Content-Transfer-Encoding: 7bit
Organization: Artisan Software, LLC
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier