Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: Windows Perl with sqlite3

by Corion (Patriarch)
on Jan 17, 2023 at 09:33 UTC ( [id://11149632]=note: print w/replies, xml ) Need Help??


in reply to Windows Perl with sqlite3

Some configuration of an SQLite database is stored in the database file. See the list of pragmata.

An easy check whether the file itself is problematic would be to copy a file from a "fast" machine to the "slow" machine and see if that makes a difference.

If it does, either that is enough, or you can look at whether the pragmata cache_size, fullfsync or journal_mode make a difference.

Replies are listed 'Best First'.
Re^2: Windows Perl with sqlite3
by miner7777 (Novice) on Jan 17, 2023 at 20:08 UTC

    That did it. Apparently the DB file was corrupted in some way but threw no errors. re-copied the original DB file to the local machine and now it flies! 100,000 selects in 11.6 seconds. Pretty good for an old machine.

    Thanks everyone!

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (6)
As of 2024-04-23 12:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found