Page 1 of 4
Giant database dbf
Posted: Tue Feb 21, 2017 9:31 pm
by 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?
Re: Giant database dbf
Posted: Wed Feb 22, 2017 8:04 am
by rdonnay
Maybe you can run ADS in Local Server mode.
Re: Giant database dbf
Posted: Wed Feb 22, 2017 9:59 am
by Eugene Lutsenko
rdonnay wrote: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.
Re: Giant database dbf
Posted: Wed Feb 22, 2017 5:37 pm
by 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
Re: Giant database dbf
Posted: Wed Feb 22, 2017 6:35 pm
by bwolfsohn
Eugene Lutsenko wrote:rdonnay wrote: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.
Re: Giant database dbf
Posted: Wed Feb 22, 2017 9:46 pm
by Eugene Lutsenko
Auge_Ohr wrote: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.
Re: Giant database dbf
Posted: Wed Feb 22, 2017 9:49 pm
by Eugene Lutsenko
bwolfsohn wrote: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?
Re: Giant database dbf
Posted: Thu Feb 23, 2017 3:46 am
by 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
Re: Giant database dbf
Posted: Thu Feb 23, 2017 7:04 am
by rdonnay
Re: Giant database dbf
Posted: Thu Feb 23, 2017 11:12 am
by 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++?