Alaska Software Inc. - PostGresql Vs ADS
Username: Password:
AuthorTopic: PostGresql Vs ADS
Scott KrisePostGresql Vs ADS
on Thu, 07 Dec 2017 11:39:21 -0500
Hello,

I'm considering upgrading from dbf/ntx to either ADS or Postgresql.

Does anyone have a preference? Key concerns are processing speed, conversion 
time, and purchase cost of the software.

Thanks,

Scott
Boris BorzicRe: PostGresql Vs ADS
on Thu, 07 Dec 2017 18:33:03 +0100
"Scott Krise" <scottkrise@verizon.net> wrote in
news:32c4cb1$5938b38b$5a49e2@news.alaska-software.com: 

> I'm considering upgrading from dbf/ntx to either ADS or Postgresql.
> 
> Does anyone have a preference? Key concerns are processing speed,
> conversion time, and purchase cost of the software.

I suggest you go with ADS. Very easy conversion, improved processing 
speed and well proven stable interface.

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
Scott KriseRe: PostGresql Vs ADS
on Thu, 07 Dec 2017 13:15:49 -0500
Thanks Boris....great information. Much appreciated.

So, what is the point where it makes sense to use the database server vs the 
local server? Number of users possibly?

I'm running into issues when using DBF/NTX without ADS is significantly 
slower when multiple users are using it across a network than when just a 
single user...and I'm hoping ADS will eliminate that issue. Do you know if 
that is the case?

"Boris Borzic" wrote in message 
news:XnsA8447FA709EACSQLExpress@87.106.143.233...

"Scott Krise" <scottkrise@verizon.net> wrote in
news:32c4cb1$5938b38b$5a49e2@news.alaska-software.com:

> I'm considering upgrading from dbf/ntx to either ADS or Postgresql.
>
> Does anyone have a preference? Key concerns are processing speed,
> conversion time, and purchase cost of the software.

I suggest you go with ADS. Very easy conversion, improved processing
speed and well proven stable interface.

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
Boris BorzicRe: PostGresql Vs ADS
on Thu, 07 Dec 2017 20:29:35 +0100
"Scott Krise" <scottkrise@verizon.net> wrote in
news:1af29b1a$50e33005$5b13e7@news.alaska-software.com: 

> Thanks Boris....great information. Much appreciated.
> 
> So, what is the point where it makes sense to use the database server
> vs the local server? Number of users possibly?

This would depend on the application... amount of data, number of users, 
amount of concurrent activity.

ADS provides better performance when there is lots of concurrent database 
activity. It also protects against index file corruption. Sometimes you can 
leave it up to the customer to decide if they will buy ADS.

> I'm running into issues when using DBF/NTX without ADS is
> significantly slower when multiple users are using it across a network
> than when just a single user...and I'm hoping ADS will eliminate that
> issue. Do you know if that is the case?

I'm pretty sure ADS will improve performance in this scenario. 

Once you start using ADS, you can also start converting parts of your code 
to use SQL (via the Advantage StreamlineSQL ODBC driver). You will find 
significant performance improvements by converting some of your reporting 
and query functions directly into SQL. The code will be simpler and will 
execute faster. The reason why it runs faster is because most of the data 
processing is done on the remote server - with the server sending back only 
the data. I have personally seen improvemens of 60x when a complex report 
accessing 3 DBF's was converted into a single SQL query using JOIN's... 20 
minutes down to 20 seconds!

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools
Scott KriseRe: PostGresql Vs ADS
on Thu, 07 Dec 2017 16:31:04 -0500
So I downloaded the client engine from the link provided. It seemed to 
install but there's nothing to execute in the program files folder, no 
desktop icon created, etc.

Can this be installed on a PC right? I tried to get in touch w SAP, and they 
sent me a link to install it too...but that’s not working either. Is ADS 
similar to a SQL server where you can log in and see your data etc, or am I 
mis-understanding how to use it?

"Boris Borzic" wrote in message 
news:XnsA8447FA709EACSQLExpress@87.106.143.233...

"Scott Krise" <scottkrise@verizon.net> wrote in
news:32c4cb1$5938b38b$5a49e2@news.alaska-software.com:

> I'm considering upgrading from dbf/ntx to either ADS or Postgresql.
>
> Does anyone have a preference? Key concerns are processing speed,
> conversion time, and purchase cost of the software.

I suggest you go with ADS. Very easy conversion, improved processing
speed and well proven stable interface.

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
Boris BorzicRe: PostGresql Vs ADS
on Thu, 07 Dec 2017 23:04:02 +0100
"Scott Krise" <scottkrise@verizon.net> wrote in
news:3fc1b5a4$4e4fa646$5d41bf@news.alaska-software.com: 

> So I downloaded the client engine from the link provided. It seemed to
> install but there's nothing to execute in the program files folder, no
> desktop icon created, etc.
> 
> Can this be installed on a PC right? I tried to get in touch w SAP,
> and they sent me a link to install it too...but that Ts not working
> either. Is ADS similar to a SQL server where you can log in and see
> your data etc, or am I mis-understanding how to use it?

You should install all of this on your development PC. You should also 
install the Data Architect (this is the GUI - like MS SQL Server Management 
Studio) + the ODBC driver (see links in earlier post).

The 'data' will be your DBF files and you can use the Data Architect to 
connect to and open your DBF files. You can also use the Data Architect to 
execute SQL statements and queries against your DBF files.

In order to access your DBF files via ADS (or ALS) from your Xbase++ 
application you will need one or more of the following:

1. Alaska ADSDBE - need to buy license from Alaska Software.

2. The ACE Wrappers (included free with SQLExpress): http://xb2.net/ace/

3. SQLExpress to access your DBF data via SQL and the Advantage ODBC 
driver. You can experiment with SQLExpress free of charge using the fully 
functional demo version.

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools
Scott KriseRe: PostGresql Vs ADS
on Thu, 07 Dec 2017 17:24:11 -0500
Ok. Found the data architect. That’s what I was looking for. Thank you!

Ill work with it and see which way I want to go on connecting it to my app, 
then Ill be in touch to see how SQL Express might be used going forward.

"Boris Borzic" wrote in message 
news:XnsA844AD980186BSQLExpress@87.106.143.233...

"Scott Krise" <scottkrise@verizon.net> wrote in
news:3fc1b5a4$4e4fa646$5d41bf@news.alaska-software.com:

> So I downloaded the client engine from the link provided. It seemed to
> install but there's nothing to execute in the program files folder, no
> desktop icon created, etc.
>
> Can this be installed on a PC right? I tried to get in touch w SAP,
> and they sent me a link to install it too...but thatƒ Ts not working
> either. Is ADS similar to a SQL server where you can log in and see
> your data etc, or am I mis-understanding how to use it?

You should install all of this on your development PC. You should also
install the Data Architect (this is the GUI - like MS SQL Server Management
Studio) + the ODBC driver (see links in earlier post).

The 'data' will be your DBF files and you can use the Data Architect to
connect to and open your DBF files. You can also use the Data Architect to
execute SQL statements and queries against your DBF files.

In order to access your DBF files via ADS (or ALS) from your Xbase++
application you will need one or more of the following:

1. Alaska ADSDBE - need to buy license from Alaska Software.

2. The ACE Wrappers (included free with SQLExpress): http://xb2.net/ace/

3. SQLExpress to access your DBF data via SQL and the Advantage ODBC
driver. You can experiment with SQLExpress free of charge using the fully
functional demo version.

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools
Scott KriseRe: PostGresql Vs ADS
on Mon, 11 Dec 2017 09:11:31 -0500
Ok...so I have a trial version of ads installed on my workstation and it 
seems to be working.

Do I just need to change my app do load ADSDBE within the dbsys() function 
to enable the use of ADS? Must I remove the load/build of the dbf and ntx 
engines?

Searching and can't seem to find any xbase documentation to guide me through 
the process. Where is that located?

Thanks,

Scott

"Boris Borzic" wrote in message 
news:XnsA844AD980186BSQLExpress@87.106.143.233...

"Scott Krise" <scottkrise@verizon.net> wrote in
news:3fc1b5a4$4e4fa646$5d41bf@news.alaska-software.com:

> So I downloaded the client engine from the link provided. It seemed to
> install but there's nothing to execute in the program files folder, no
> desktop icon created, etc.
>
> Can this be installed on a PC right? I tried to get in touch w SAP,
> and they sent me a link to install it too...but thatƒ Ts not working
> either. Is ADS similar to a SQL server where you can log in and see
> your data etc, or am I mis-understanding how to use it?

You should install all of this on your development PC. You should also
install the Data Architect (this is the GUI - like MS SQL Server Management
Studio) + the ODBC driver (see links in earlier post).

The 'data' will be your DBF files and you can use the Data Architect to
connect to and open your DBF files. You can also use the Data Architect to
execute SQL statements and queries against your DBF files.

In order to access your DBF files via ADS (or ALS) from your Xbase++
application you will need one or more of the following:

1. Alaska ADSDBE - need to buy license from Alaska Software.

2. The ACE Wrappers (included free with SQLExpress): http://xb2.net/ace/

3. SQLExpress to access your DBF data via SQL and the Advantage ODBC
driver. You can experiment with SQLExpress free of charge using the fully
functional demo version.

Best regards,
Boris Borzic

http://xb2.net
http://sqlexpress.net
industrial strength Xbase++ development tools
Jonathan LeemingRe: PostGresql Vs ADS
on Tue, 12 Dec 2017 10:09:45 -0700
On 12/11/2017 7:11 AM, Scott Krise wrote:
> Ok...so I have a trial version of ads installed on my workstation and it 
> seems to be working.
> 
> Do I just need to change my app do load ADSDBE within the dbsys() 
> function to enable the use of ADS? Must I remove the load/build of the 
> dbf and ntx engines?
> 
> Searching and can't seem to find any xbase documentation to guide me 
> through the process. Where is that located?
> 
> Thanks,
> 
> Scott
> 
> "Boris Borzic" wrote in message 
> news:XnsA844AD980186BSQLExpress@87.106.143.233...
> 
> "Scott Krise" <scottkrise@verizon.net> wrote in
> news:3fc1b5a4$4e4fa646$5d41bf@news.alaska-software.com:
> 
>> So I downloaded the client engine from the link provided. It seemed to
>> install but there's nothing to execute in the program files folder, no
>> desktop icon created, etc.
>>
>> Can this be installed on a PC right? I tried to get in touch w SAP,
>> and they sent me a link to install it too...but thatƒ Ts not working
>> either. Is ADS similar to a SQL server where you can log in and see
>> your data etc, or am I mis-understanding how to use it?
> 
> You should install all of this on your development PC. You should also
> install the Data Architect (this is the GUI - like MS SQL Server Management
> Studio) + the ODBC driver (see links in earlier post).
> 
> The 'data' will be your DBF files and you can use the Data Architect to
> connect to and open your DBF files. You can also use the Data Architect to
> execute SQL statements and queries against your DBF files.
> 
> In order to access your DBF files via ADS (or ALS) from your Xbase++
> application you will need one or more of the following:
> 
> 1. Alaska ADSDBE - need to buy license from Alaska Software.
> 
> 2. The ACE Wrappers (included free with SQLExpress): http://xb2.net/ace/
> 
> 3. SQLExpress to access your DBF data via SQL and the Advantage ODBC
> driver. You can experiment with SQLExpress free of charge using the fully
> functional demo version.
> 
Hi Scott,

Roger Donnay (a rather talented developer) wrate a white paper a number 
of years back:

http://donnay-software.com/ds/Articles/Sybase_Advantage_Xbase++_GettingStarted_Guide_wp.pdf

It may be of some use to you.

Regards... Jontahan
Scott KriseRe: PostGresql Vs ADS
on Thu, 14 Dec 2017 09:12:12 -0500
Thanks Jonathan! Good information.

"Jonathan Leeming" wrote in message 
news:33fda731$eb543d9$10174@news.alaska-software.com...

On 12/11/2017 7:11 AM, Scott Krise wrote:
> Ok...so I have a trial version of ads installed on my workstation and it 
> seems to be working.
>
> Do I just need to change my app do load ADSDBE within the dbsys() function 
> to enable the use of ADS? Must I remove the load/build of the dbf and ntx 
> engines?
>
> Searching and can't seem to find any xbase documentation to guide me 
> through the process. Where is that located?
>
> Thanks,
>
> Scott
>
> "Boris Borzic" wrote in message 
> news:XnsA844AD980186BSQLExpress@87.106.143.233...
>
> "Scott Krise" <scottkrise@verizon.net> wrote in
> news:3fc1b5a4$4e4fa646$5d41bf@news.alaska-software.com:
>
>> So I downloaded the client engine from the link provided. It seemed to
>> install but there's nothing to execute in the program files folder, no
>> desktop icon created, etc.
>>
>> Can this be installed on a PC right? I tried to get in touch w SAP,
>> and they sent me a link to install it too...but thatƒ Ts not working
>> either. Is ADS similar to a SQL server where you can log in and see
>> your data etc, or am I mis-understanding how to use it?
>
> You should install all of this on your development PC. You should also
> install the Data Architect (this is the GUI - like MS SQL Server 
> Management
> Studio) + the ODBC driver (see links in earlier post).
>
> The 'data' will be your DBF files and you can use the Data Architect to
> connect to and open your DBF files. You can also use the Data Architect to
> execute SQL statements and queries against your DBF files.
>
> In order to access your DBF files via ADS (or ALS) from your Xbase++
> application you will need one or more of the following:
>
> 1. Alaska ADSDBE - need to buy license from Alaska Software.
>
> 2. The ACE Wrappers (included free with SQLExpress): http://xb2.net/ace/
>
> 3. SQLExpress to access your DBF data via SQL and the Advantage ODBC
> driver. You can experiment with SQLExpress free of charge using the fully
> functional demo version.
>
Hi Scott,

Roger Donnay (a rather talented developer) wrate a white paper a number
of years back:

http://donnay-software.com/ds/Articles/Sybase_Advantage_Xbase++_GettingStarted_Guide_wp.pdf

It may be of some use to you.

Regards... Jontahan