What is the maximum number that can be written to the database?
Posted: 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)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?
more Field -> less Records to reach 2 GB.Tabellen Dateigröße Limitiert auf 2^31 Bytes (2 Gigabyte)
Max. Anzahl Felder 2038 *)
Max. Anzahl Datensätze (2^31 - Header() - 1) / RecSize()
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 )