Re: What is best VCL to use with MS Access?

Article View: comp.lang.pascal.delphi.databases

Article #126

Back to comp.lang.pascal.delphi.databases Previous Next

#126

From: Andre Joubert
Date: Wed, 13 May 1998 00:00

20 lines
1408 bytes

Don,

Access wasn't designed as a heavy duty database - anything over 50 000
records will result in a major deterioration in performance - you
might try using Foxpro tables, which will support upwards of 5 mill
records without too much trouble - larger than that, you should
probably be looking at Oracle or somesuch

HTH,

Andre Joubert


On Mon, 11 May 1998 22:26:23 -0400, "Don F. Ridgway"
<dridgway@ix.netcom.com> wrote:

>	I have seen ODBC Express take ten minutes to open a (unindexed)
>quarter-million record Access table.  That is unacceptable.  Why did it
 ^^^^^^^^^^^^^^^ ^^^^^^

Technical Details

Message-ID: <3559e045.167965003@news.iafrica.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <3557B34F.17EF@ix.netcom.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,c8f4e8c299767c59
X-Google-Attributes: gidffff5,public
X-Google-Thread: ff75c,c8f4e8c299767c59
X-Google-Attributes: gidff75c,public
X-Google-Thread: f8256,c8f4e8c299767c59
X-Google-Attributes: gidf8256,public
X-Google-Thread: 10de66,c8f4e8c299767c59
X-Google-Attributes: gid10de66,public
From: ribbit@eastcoast.co.za (Andre Joubert)
Subject: Re: What is best VCL to use with MS Access?
Date: 1998/05/13
Message-ID: <3559e045.167965003@news.iafrica.com>
X-Deja-AN: 352944918
References: <3557B34F.17EF@ix.netcom.com>
Organization: UUNET Internet Africa
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop,borland.public.delphi.database.sqlservers,borland.public.delphi.thirdparty-tools

Reply to Parent Message