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

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.
  • Comment on Re^15: threads::shared seems to kill performance (Workaround).

Replies are listed 'Best First'.
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.