Re: maximum number of record
Christian: Thank you for posting that link. Hmm, *only* 1 billion… -- Douglas von Roeder 949-910-4084 On Fri, Dec 13, 2019 at 12:29 PM Christian Sakowski via 4D_Tech < 4d_tech@lists.4d.com> wrote: > > a longint value for record numbers - (2^64)-1 > > The C_LONGINT is 2^32 which is 4 billion. Signed 2 billion. > Starting with v11 (alias 4D 2007), i guess internally the addressable is > 128 bit! Now you can calculate the technical limit of each resource :-) > > As i said, the „artificial“ limit is 1.000.000.000: > > https://doc.4d.com/4Dv18/4D/18/4D-Database-capabilities.300-4575575.en.html > -- > > Grüße/Regards, > [heubach-media] | Christian Sakowski > christian.sakow...@heubach-media.de > Tel: +49/(0)40/41 455 455 > > > > > > > Am 13.12.2019 um 16:26 schrieb Chip Scheide via 4D_Tech < > 4d_tech@lists.4d.com>: > > > > someone else will correct me if I am wrong, but I believe it is ~2 > > billion. > > a longint value for record numbers - (2^64)-1 > > > > Chip > > On Fri, 13 Dec 2019 16:13:35 +0100, stardata.info via 4D_Tech wrote: > >> Hi All, > >> > >> In one my application in 4D V13.4 on Windows, i have in one table > >> over of 8.000.000 records. > >> > >> What is the maximum number of records that 4D V13.4 can manage? > >> > >> Thanks > >> > >> Ferdinando > >> > >> ** > >> 4D Internet Users Group (4D iNUG) > >> Archive: http://lists.4d.com/archives.html > >> Options: https://lists.4d.com/mailman/options/4d_tech > >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > >> ** > > We have done so much, with so little, for so long; > > We are now qualified to anything with nothing > > - unknown > > ** > > 4D Internet Users Group (4D iNUG) > > Archive: http://lists.4d.com/archives.html > > Options: https://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > ** > > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: maximum number of record
> a longint value for record numbers - (2^64)-1 The C_LONGINT is 2^32 which is 4 billion. Signed 2 billion. Starting with v11 (alias 4D 2007), i guess internally the addressable is 128 bit! Now you can calculate the technical limit of each resource :-) As i said, the „artificial“ limit is 1.000.000.000: https://doc.4d.com/4Dv18/4D/18/4D-Database-capabilities.300-4575575.en.html -- Grüße/Regards, [heubach-media] | Christian Sakowski christian.sakow...@heubach-media.de Tel: +49/(0)40/41 455 455 > Am 13.12.2019 um 16:26 schrieb Chip Scheide via 4D_Tech > <4d_tech@lists.4d.com>: > > someone else will correct me if I am wrong, but I believe it is ~2 > billion. > a longint value for record numbers - (2^64)-1 > > Chip > On Fri, 13 Dec 2019 16:13:35 +0100, stardata.info via 4D_Tech wrote: >> Hi All, >> >> In one my application in 4D V13.4 on Windows, i have in one table >> over of 8.000.000 records. >> >> What is the maximum number of records that 4D V13.4 can manage? >> >> Thanks >> >> Ferdinando >> >> ** >> 4D Internet Users Group (4D iNUG) >> Archive: http://lists.4d.com/archives.html >> Options: https://lists.4d.com/mailman/options/4d_tech >> Unsub: mailto:4d_tech-unsubscr...@lists.4d.com >> ** > We have done so much, with so little, for so long; > We are now qualified to anything with nothing > - unknown > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: maximum number of record
someone else will correct me if I am wrong, but I believe it is ~2 billion. a longint value for record numbers - (2^64)-1 Chip On Fri, 13 Dec 2019 16:13:35 +0100, stardata.info via 4D_Tech wrote: > Hi All, > > In one my application in 4D V13.4 on Windows, i have in one table > over of 8.000.000 records. > > What is the maximum number of records that 4D V13.4 can manage? > > Thanks > > Ferdinando > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** We have done so much, with so little, for so long; We are now qualified to anything with nothing - unknown ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: maximum number of record
2 billion per table On Fri, Dec 13, 2019 at 7:21 AM Tom Benedict via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I’ve had systems where tables had 10 million records in ‘wide’ (200+ > fields) tables. And over 50,000,000 in ‘narrow’ (10 fields) tables. That > was under v13.x. I think you should be fine. Of course you must only do > indexed queries. > > HTH, > > Tom Benedict > > > On Dec 13, 2019, at 07:13, stardata.info via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > > > > Hi All, > > > > In one my application in 4D V13.4 on Windows, i have in one table over > of 8.000.000 records. > > > > What is the maximum number of records that 4D V13.4 can manage? > > > > Thanks > > > > Ferdinando > > > > ** > > 4D Internet Users Group (4D iNUG) > > Archive: http://lists.4d.com/archives.html > > Options: https://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > ** > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- -- Douglas von Roeder 949-910-4084 ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: maximum number of record
I’ve had systems where tables had 10 million records in ‘wide’ (200+ fields) tables. And over 50,000,000 in ‘narrow’ (10 fields) tables. That was under v13.x. I think you should be fine. Of course you must only do indexed queries. HTH, Tom Benedict > On Dec 13, 2019, at 07:13, stardata.info via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi All, > > In one my application in 4D V13.4 on Windows, i have in one table over of > 8.000.000 records. > > What is the maximum number of records that 4D V13.4 can manage? > > Thanks > > Ferdinando > > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
maximum number of record
Hi All, In one my application in 4D V13.4 on Windows, i have in one table over of 8.000.000 records. What is the maximum number of records that 4D V13.4 can manage? Thanks Ferdinando ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
