What is the maximum number that can be written to the database?

This forum is for eXpress++ general support.
Post Reply
Message
Author
User avatar
Eugene Lutsenko
Posts: 1649
Joined: Sat Feb 04, 2012 2:23 am
Location: Russia, Southern federal district, city of Krasnodar
Contact:

What is the maximum number that can be written to the database?

#1 Post by Eugene Lutsenko »

What is the maximum number that can be written to the database? What structure should it have for this?

User avatar
Auge_Ohr
Posts: 1405
Joined: Wed Feb 24, 2010 3:44 pm

Re: What is the maximum number that can be written to the database?

#2 Post by Auge_Ohr »

Eugene Lutsenko wrote: Thu Oct 15, 2020 7:41 pm What is the maximum number that can be written to the database?
What structure should it have for this?
look at FOXDBE (DATA-Komponente)
Tabellen Dateigröße Limitiert auf 2^31 Bytes (2 Gigabyte)
Max. Anzahl Felder 2038 *)
Max. Anzahl Datensätze (2^31 - Header() - 1) / RecSize()
more Field -> less Records to reach 2 GB.

the Problem is DBFDBE_LOCKOFFSET which default is 1000000000 which is Cl*pper compatible
you can change to max. 2.4GB using 8FFFFFFF (not 0x80000000 )

but this is not compatible any more :!:

---

under harbour you can use extend DBF up to 2^41 -> 2TB (Terabyte) max file size

have found this Message
https://groups.google.com/forum/#!topic ... Fc6qLTERi8

Code: Select all

#include "dbinfo.ch"
...
 set( _SET_DBFLOCKSCHEME, DB_DBFLOCK_HB64 )
but it need 64 Bit App
greetings by OHR
Jimmy

Post Reply