Giant database dbf

[Eugene Lutsenko]

I am constantly faced with the fact that I am not content to have the maximum size of the database of type dbf to 2GB. ADS are inconvenient to use, as the system is my Aidos runs on many computers on which you do not want something to install: http://j90540lw.beget.tech/map4.php. The question arises: it may be possible to adjust something in the header of the database type is dbf, to remove the restrictions on the 2 GB?

[rdonnay]

Maybe you can run ADS in Local Server mode.

[Eugene Lutsenko]

Maybe you can run ADS in Local Server mode.

I can long ago launched, back in 2012, as soon as began to use Alaska. But for others it will be uncomfortable. Not all will be able and will to use it. Often the user generally do not know how or does not have rights to install. That's why I ask.

PS
For the same reason I don't use Rmchart, although I personally liked it and I made it much beautiful and dynamic graphic forms.

[Auge_Ohr]

Xbase (all Version) Database are not design for Network. "Share" must be simulated.

Xbase use "locking" with Maxlimit +1 so if you want to lock Record at 2GB than "lock" is at 4 GB +1
32bit OS() can only handle 2^32 -> 4 GB so you can't use > than 2GB Xbase Database/Index Files

harbour have 64bit Version. Years ago the break 4GB Limit and now reach 2^42 is 4TB
https://vivaclipper.wordpress.com/tag/rdd/

or use SQLite (not for Network), like Windows 10 with UWA (Universal Windows Platform),
which can handle

Max DB size: 140 terabytes (247 bytes)
Max row size: 1 gigabyte

[bwolfsohn]

Maybe you can run ADS in Local Server mode.

I can long ago launched, back in 2012, as soon as began to use Alaska. But for others it will be uncomfortable. Not all will be able and will to use it. Often the user generally do not know how or does not have rights to install. That's why I ask.

PS
For the same reason I don't use Rmchart, although I personally liked it and I made it much beautiful and dynamic graphic forms.

Ads local server does not require installation...

it's just dll's and an .ini file.

[Eugene Lutsenko]

Xbase (all Version) Database are not design for Network. "Share" must be simulated.

Xbase use "locking" with Maxlimit +1 so if you want to lock Record at 2GB than "lock" is at 4 GB +1
32bit OS() can only handle 2^32 -> 4 GB so you can't use > than 2GB Xbase Database/Index Files

harbour have 64bit Version. Years ago the break 4GB Limit and now reach 2^42 is 4TB
https://vivaclipper.wordpress.com/tag/rdd/

or use SQLite (not for Network), like Windows 10 with UWA (Universal Windows Platform),
which can handle

Max DB size: 140 terabytes (247 bytes)
Max row size: 1 gigabyte

Yeah, I remember that CLIPPER was a limit on the database size 4Gb.

[Eugene Lutsenko]

Ads local server does not require installation...

it's just dll's and an .ini file.

Then it's a different matter and is of great interest. And where to get these DLLs s and and ini files?

[unixkd]

Hi

1. Download the advantage data Architect from SAP website. It contains the DLLs for Local Server.

2. Take note of capabilities available in the SERVER version but NOT in the Local Server e.g TRANSACTION processing etc

3. Sincerely there is no real reason not to use ADS if you program Xbase++

Thanks.

Joe

[rdonnay]

Here are the files you need.

http://bb.donnay-software.com/advantage/arc32.zip

[Eugene Lutsenko]

Thank you all! I will learn to use it. Maybe someone have a small example prg-file in Alaska with the implementation of the basic functions of working with databases through ADS?

I would like to use the ISAM interface to work with databases and ADS (SQL does not want). I wonder, is it possible to display ADS base standard Alaska and eXpress++?