Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re^6: looping efficiency

by karlgoethebier (Abbot)
on Dec 30, 2020 at 13:42 UTC ( [id://11125995]=note: print w/replies, xml ) Need Help??


in reply to Re^5: looping efficiency
in thread looping efficiency

"...even SQLite..."

See limits.

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

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]

      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]
        Guten rutsch ins neue Jahr!

        Update: In English: "Happy New Year!".
        You can say: "Gesundes Neues” in the first days of January.

[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://11125995]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others exploiting the Monastery: (3)
As of 2024-04-19 20:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found