Re: [sqlite] sqlite-users Digest, Vol 126, Issue 13

2018-06-13 Thread Simone Mosciatti
Hi folks, I already posted this message but I believe there was some error or issue with nabble and I am not sure it was received, if you already got it, please sorry a lot for the noise. == Hi All, I am facing a quite interesting problem. I am trying to implement a new

[sqlite] SQLite between forks

2018-03-26 Thread Simone Mosciatti
Hi all, it is suggested in several place to don't share a connection between forks. However I fail to see how this can be a problem for purely in-memory database. If my understanding of fork and sqlite are correct I don't see issues in having a forked child reading a database connection

Re: [sqlite] sqlite-users Digest, Vol 111, Issue 2

2017-03-02 Thread Simone Mosciatti
n 03/01/2017 09:53 PM, Simone Mosciatti wrote: Hi all, tl;dr: What are the difference between running SQLite inside TCL and running it embed in a shared object module? Why I am seeing such big difference in performance? https://github.com/RedBeardLab/rediSQL/issues/13#issuecomment-283309641

[sqlite] Performance difference in running SQLite embed or in a TCL script

2017-03-01 Thread Simone Mosciatti
Hi all, tl;dr: What are the difference between running SQLite inside TCL and running it embed in a shared object module? Why I am seeing such big difference in performance? https://github.com/RedBeardLab/rediSQL/issues/13#issuecomment-283309641 I finally got some time to work again on my

Re: [sqlite] sqlite-users Digest, Vol 109, Issue 7

2017-01-07 Thread Simone Mosciatti
Hi James, sorry I didn't see you email earlier... No idea why... You are completely right on your question. However to answer those question I would need to know how rediSQL would be used, which I can't. Right now I can only deference those choice to whoever is using it. /2) I need some

Re: [sqlite] sqlite-users Digest, Vol 109, Issue 7

2017-01-07 Thread Simone Mosciatti
109, Issue 6 Message-ID:<3b949654-42c0-4253-8965-f0edf1a89...@bigfraud.org> Content-Type: text/plain; charset=us-ascii On 6 Jan 2017, at 3:20pm, Simone Mosciatti<sisciamir...@yahoo.com> wrote: 1. Retrieve the connection object inside Redis 2. Parse the SQL statement (sqlite

Re: [sqlite] sqlite-users Digest, Vol 109, Issue 6

2017-01-06 Thread Simone Mosciatti
Hi Dan, I run your TCL script and I can confirm that I am seeing values extremely different, in my machine, the same that I used for the previous test, I got a rather stable 240k insert per second. In my understanding my code is not doing anything different. The only difference is the

[sqlite] Performance degradation of in-memory database with high row count and overall design discussion of my project

2017-01-05 Thread Simone Mosciatti
Hi all, I am writing a small Redis module that embeds SQLite [1] I am facing some performance issues and I wonder if the behaviour I am seeing is expected or if I am doing something completely wrong. I would provide some context on what I am doing, hoping that you may see some flaw in my