Article View: comp.lang.pascal.delphi.databases
Article #40Re: Same application, different databases? Scaleability?
From: Tony Lees
Date: Mon, 27 Sep 1999 00:00
Date: Mon, 27 Sep 1999 00:00
52 lines
2817 bytes
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-mailReferences:
<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