Re^14: threads::shared seems to kill performance (Workaround).

After recompiling the SQLite used by DBD::SQLite with SQLITE_USE_URI, it works flawlessly!

Btw I did read that document about 17 times, but I always skipped the Backwards compatibility section as not important and focused on the Format instead. And then banged my head against the wall wondering why it doesn't work :-(

Just one last thing - do you know if I can somehow use any of those other 2 ways to enable this via DBD::SQLite? I want to avoid having to recompile SQLite on every machine on which I use this. They seem to be meant primarily for the C interface, but I wonder if there's some way to invoke them from Perl as well:

The sqlite3_config(SQLITE_CONFIG_URI, 1); configuration option is set at application start-time.
The SQLITE_OPEN_URI bit is OR-ed in with the set bits passed in as the 3rd parameter to the sqlite3_open_v2() interface.

Comment on Re^14: threads::shared seems to kill performance (Workaround).

Replies are listed 'Best First'.
Re^15: threads::shared seems to kill performance (Workaround). by BrowserUk (Patriarch) on Jul 25, 2013 at 06:46 UTC
After recompiling the SQLite used by DBD::SQLite with SQLITE_USE_URI, it works flawlessly! That's great news. I'll get around to trying it here sometime soon. Just one last thing - do you know if I can somehow use any of those other 2 ways to enable this via DBD::SQLite? I don't know. My assumption is that unless it is enabled at compile time, it won't work. I guess if passing the appropriate options/parameters can override the compile-time setting (at the C interface), then it would be possible to pass-through an option from Perl to the XS code to do the same. But either way would require the DBD::Sqlite author to patch his code; and adding the compile-time define seems simpler to me. If you have time and inclination you might try emailing the author (of DBD::Sqlite(2)) and make your case for enabling this by default. With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday' Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice.	[reply]
Re^16: threads::shared seems to kill performance (Workaround). by Jacobs (Novice) on Jul 25, 2013 at 12:22 UTC
I've written to one of the authors and he suggested I open a bug report instead, so in case you want to follow the progress, it's this one.	[reply]