Tamaño DBF-DBT / Size DBF-DBT

Moderator: Rathinagiri

Post Reply
JALMAG
Posts: 262
Joined: Sun Jan 10, 2010 7:05 pm
DBs Used: DBF, MariaDB
Location: España - Spain

Tamaño DBF-DBT / Size DBF-DBT

Post by JALMAG »

Hola amigos, creo que no está documentado el tamaño de los archivos DBF-DBT-CDX (NTX) que puede gestionar Harbour, me refiero a si existe un tamaño a partir del cual se hace difícil su gestión. ¿Alguien lo sabe?

Muchas gracias

English translate

Hello friends, I think it is documented DBF file sizes-DBT-CDX (NTX) that can handle Harbour, I mean if there is a size at which it becomes difficult to manage. Does anyone know?

Best regards
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by bpd2000 »

BPD
Convert Dream into Reality through HMG
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by esgici »

JALMAG wrote:I think it is documented DBF file sizes-DBT-CDX (NTX) that can handle Harbour, I mean if there is a size at which it becomes difficult to manage. Does anyone know?
Hola Jalmag

If you are about size of file in bytes on disk; you can determine size of ANY file by FILESIZE() function;

you can look at here for details.

Happy HMG :D
Viva INTERNATIONAL HMG :D
JALMAG
Posts: 262
Joined: Sun Jan 10, 2010 7:05 pm
DBs Used: DBF, MariaDB
Location: España - Spain

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by JALMAG »

JALMAG
Posts: 262
Joined: Sun Jan 10, 2010 7:05 pm
DBs Used: DBF, MariaDB
Location: España - Spain

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by JALMAG »

esgici wrote:
JALMAG wrote:I think it is documented DBF file sizes-DBT-CDX (NTX) that can handle Harbour, I mean if there is a size at which it becomes difficult to manage. Does anyone know?
Hola Jalmag

If you are about size of file in bytes on disk; you can determine size of ANY file by FILESIZE() function;

you can look at here for details.

Happy HMG :D
Thanks master esgici, but the data I want, is the maximum size that can be managed (x) Harbour no problems with the file. 2Gb o more?
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by bpd2000 »

BPD
Convert Dream into Reality through HMG
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by esgici »

JALMAG wrote:...the data I want, is the maximum size that can be managed (x) Harbour no problems with the file. 2Gb o more?
OK, you are about size limits; I missed can handle clause, sorry :(

Harbour file size limits are :
  • Max record size: 2^16-1 = 65535 byts ( 64 MB )
    Max number of recors : 2^32-1 = 4,294,967,295
    Max .dbf file size : 2^48 = 256 TB

    Max DBT memo file size : 2 TB
    Max FPT memo file size : 256 GB
    Max SMT memo file size : 128 GB

    Max NTX file size (standard) : 4GB
    Max NTX file size (incresead ) : 4TB

    Max CDX file size : 4GB
For more info please look at ### NATIVE RDDs ### section in Harbour\doc\xhb-diff.txt .

Happy HMG :D
Last edited by esgici on Sat Nov 09, 2013 11:36 am, edited 1 time in total.
Viva INTERNATIONAL HMG :D
JALMAG
Posts: 262
Joined: Sun Jan 10, 2010 7:05 pm
DBs Used: DBF, MariaDB
Location: España - Spain

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by JALMAG »

Thank you very much! master esgici
Best regards
User avatar
esgici
Posts: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Contact:

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by esgici »

Please, I'm not a master :oops:

simply a worker :arrow:

Happy HMG :D
Viva INTERNATIONAL HMG :D
JALMAG
Posts: 262
Joined: Sun Jan 10, 2010 7:05 pm
DBs Used: DBF, MariaDB
Location: España - Spain

Re: Tamaño DBF-DBT / Size DBF-DBT

Post by JALMAG »

In HMG is the head master Roberto Lopez and masters Esgici & Rathinagiri, that is quite true
Best regards!
Post Reply