Re^6: looping efficiency

"...even SQLite..."

From ibidem:

"Every database consists of one or more "pages". Within a single database, every page is the same size, but different database can have page sizes that are powers of two between 512 and 65536, inclusive. The maximum size of a database file is 4294967294 pages. At the maximum page size of 65536 bytes, this translates into a maximum database size of approximately 1.4e+14 bytes (281 terabytes, or 256 tebibytes, or 281474 gigabytes or 256,000 gibibytes)."

Should be enough i guess.

«The Crux of the Biscuit is the Apostrophe»

perl -MCrypt::CBC -E 'say Crypt::CBC->new(-key=>'kgb',-cipher=>"Blowfish")->decrypt_hex($ENV{KARL});'Help

Comment on Re^6: looping efficiency Download Code

Replies are listed 'Best First'.
Re^7: looping efficiency by Marshall (Canon) on Dec 31, 2020 at 22:03 UTC
Thank you for the excellent link! The SQlite file will have to fit within the maximum file size for a particular O/S's filesystem. Some adjustments to various SQLite parameters as referenced in your link may have to be adjusted. I have never done so, but I am confident that my 64 bit Windows NTFS file system can deal with a 25GB file.	[reply]
Re^8: looping efficiency by karlgoethebier (Abbot) on Dec 31, 2020 at 22:37 UTC
Gern geschehen! «The Crux of the Biscuit is the Apostrophe» `perl -MCrypt::CBC -E 'say Crypt::CBC->new(-key=>'kgb',-cipher=>"Blowfish")->decrypt_hex($ENV{KARL});'`Help	[reply] [d/l]
Re^9: looping efficiency by Marshall (Canon) on Jan 01, 2021 at 00:15 UTC
Guten rutsch ins neue Jahr! Update: In English: "Happy New Year!". You can say: "Gesundes Neues” in the first days of January.	[reply]