Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re^2: DBI::SQLite slowness

by Laurent_R (Monsignor)
on Sep 21, 2013 at 09:24 UTC ( #1055119=note: print w/ replies, xml ) Need Help??

in reply to Re: DBI::SQLite slowness
in thread DBI::SQLite slowness

I tried that a couple of time, the performance on inserting new records just became really bad. It may be OK when the DB file already exists and is more or less static, but apparently not when you are constantly adding new records. It may also be that I did not do it the right way, but I tried various things, I don't see what I might have done wrong.

Comment on Re^2: DBI::SQLite slowness
Replies are listed 'Best First'.
Re^3: DBI::SQLite slowness
by Jenda (Abbot) on Sep 21, 2013 at 16:10 UTC

    It will always be quite a bit slower than when the hash fits in memory, but still much quicker than if the hash grows so big that the computer has to swap memory pages onto disk.

    Enoch was right!
    Enjoy the last years of Rome.


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1055119]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (8)
As of 2015-12-02 07:32 GMT
Find Nodes?
    Voting Booth?

    My keyboard shows this many letters:

    Results (35 votes), past polls