Re: multithreaded app with in-memory database and transactions

Jim Dodgen <[email protected]>
Newsgroups gmane.comp.db.sqlite.general
Message-ID <CAJ2wgcqUn5dZFf=CZrOBTqcWFBDkZj4HMdvFT6CTzv6XNrcM+Q@mail.gmail.com>
I have often wondered what the performance difference is between /dev/shm
and :memory: databases

Jim "Jed" Dodgen
[email protected]


On Thu, Feb 13, 2020 at 4:48 PM Keith Medcalf <[email protected]> wrote:

>
> On Thursday, 13 February, 2020 17:06, Jim Dodgen <[email protected]>
> wrote:
>
> >I have placed databases on/in /dev/shm and shared them across both
> >threads and processes.
>
> Yeah, /dev/shm is a pre-existing tmpfs filesystem, separate from the one
> mounted on /tmp.  I keep forgetting about that one ...
>
> --
> The fact that there's a Highway to Hell but only a Stairway to Heaven says
> a lot about anticipated traffic volume.
>
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.