Subject Re: delete row in dataset
From Boris Borzic <bb> <Boris Borzic <bb>>
Date Sat, 9 Jun 2018 15:33:44 +0200
Newsgroups sqlexpress

Victorio <> wrote in news:7h2k8f0g2u7lffv.090620181458@daz17:

> I must examine also replace ORDER BY from SELECT to :setorder() to
> compare speed, because now when compare "SQL" system with old DBF/CDX,
> SQL open databases slowly mainly when database is on remote server.

Suggest you look at Advantage Database Server. It has a much better ODBC
driver and in a multi-user environment ADS has better speed, supports
transactions and greatly reduces chance of database corruption.

Note that Advantage provides 2 interfaces:

1. ADS (Advantage Database Server) - this is client/server version where
ADS is installed on a separate server and your Xbase++ applications
connect to & access DBF files through ADS. You (or your customers) need
to buy a license for ADS.

2. ALS (Advantage Local Server) - this is the free (file-based) version
where each Xbase++ application connects to the DBF files directly via the
ADSLOC32.DLL.

By modifying an ADS.INI file, you can control how your application
connects to Advantage. For example in testing/development and small
systems you can use the free ALS and for large production databases you
can use ADS. No code changes needed!

Some additional info here: http://xb2.net/ace/
and direct links to download Advantage clients:

Advantage Client Engine:
http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=19
&Product=5&Platform=6

Advantage Data Architect:
http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=19
&Product=8&Platform=6

Advantage StreamlineSQL ODBC driver (optional):
http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=19
&Product=14&Platform=6

--
Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools

Recent messages in this thread
 
-# delete row in dataset Victorio <> 08-Jun-2018 03:26 pm
.-# Re: delete row in dataset Andreas Gehrs-Pahl 08-Jun-2018 05:24 pm
..-# Re: delete row in dataset Boris Borzic <bb> 08-Jun-2018 06:56 pm
...-# Re: delete row in dataset Victorio <> 09-Jun-2018 08:58 am
...|-# Re: delete row in dataset (Current message) Boris Borzic <bb> 09-Jun-2018 09:33 am
...|.\# Re: delete row in dataset Victorio <> 09-Jun-2018 10:19 am
...\# Re: delete row in dataset Victorio <> 10-Jun-2018 01:50 pm