🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Same application, different databases? Scaleability?

#40
From: Tony Lees
Date: Mon, 27 Sep 1999 00:00
52 lines
2817 bytes
Marco

tanti grazi encore - I think :)

Your input has been very helpful and I think we have a better idea now
of which way to go.


mrocciNOSPAM@tin.it (Marco Rocci) wrote:

<snipped>
>>
>>Do you have any feel for how comprehensive LOCALSQL is?  For instance,
>>if Paradox was used, will LOCALSQL place limitations on what can be
>>done - or are all the "normal" database functions catered for?
>
>LocalSQL covers most of the "normal" database functions.  A complete
>list of unsupported SQL language elements can be found in LocalSQL.hlp
>(if you have the updated help file).
>
>I'd say that the most useful thing missing is the ability to create
>and mantain constraint via SQL.  Be aware that you *can* have
>constraints on the Paradox table (appropriate level)... you just can't
>create tables with CHECKs and FOREIGN KEYs by using a TQuery.
>
>I have to say that I don't create or restructure dbs by using Delphi
>apps anyway... so I can live without it.
>
>Your real issue is speed.  To have Paradox scream on a LAN you might
>have to use TTables and indices instead of TQueries.
>
>If you go the InterBase way... you can easily scale down to Local
>InterBase Server.  You can deploy that for 20$-60$ per seat (depending
>on how many you intend to deploy).  It's fully compatible with the
>InterBase Server (the gdb files can be copied and opened by both).
>Administration is easy.  It might be a bit slower than Paradox on a
>single user PC, but it really means you have to add
>*not*a*single*line*of*code* to make it work on both.
>
>Regards,
>
>--
>Marco Rocci
>MicroEra srl
>Turin, Italy
>-----------------
>vota contro lo SPAM su: http://www.politik-digital.de/spam/


Tony Lees

Put a dash instead of dash if emailing me
Technical Details
Message-ID: <37ef761e.17601063@news.u-net.net>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail
References: <37dd0e77.21814243@news.u-net.net> <ZFTeN8I5J6XPbRu0ClSnmXrznpVt@4ax.com> <37e2319c.14704628@news.u-net.net> <uwTmNyivKAGFroBMxvmGYEb2OSY2@4ax.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,909a24479f9173d1
X-Google-Attributes: gidffff5,public
X-Google-Thread: ff75c,909a24479f9173d1
X-Google-Attributes: gidff75c,public
X-Google-Thread: 10de66,909a24479f9173d1
X-Google-Attributes: gid10de66,public
From: tonylees@datarev.udashnet.com (Tony Lees)
Subject: Re: Same application, different databases? Scaleability?
Date: 1999/09/27
Message-ID: <37ef761e.17601063@news.u-net.net>
X-Deja-AN: 529870866
References: <37dd0e77.21814243@news.u-net.net> <ZFTeN8I5J6XPbRu0ClSnmXrznpVt@4ax.com> <37e2319c.14704628@news.u-net.net> <uwTmNyivKAGFroBMxvmGYEb2OSY2@4ax.com>
X-Complaints-To: news@u-net.net
X-Trace: newsr2.u-net.net 938440431 195.102.200.201 (Mon, 27 Sep 1999 14:53:51 BST)
Organization: (Posted via) U-NET Internet Ltd.
Reply-To: tonylees@datarev.udashnet.com
NNTP-Posting-Date: Mon, 27 Sep 1999 14:53:51 BST
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop,borland.public.delphi.database.sqlservers