Hi Simon,
yes, of course I am doing the sequence prepare(), step()*, finalize()
Starts from here:
https://github.com/RedBeardLab/rediSQL/blob/master/rediSQL.c#L174
However, even if I wasn't do it, I should just see an increase in
memory, not a so steep decrease in performance, correct?
Thanks,
Simone
On 07/01/2017 13:00, sqlite-users-requ...@mailinglists.sqlite.org wrote:
Message: 6
Date: Fri, 6 Jan 2017 15:35:02 +0000
From: Simon Slavin<slav...@bigfraud.org>
To: SQLite mailing list<sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] sqlite-users Digest, Vol 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 (sqlite3_prepare_v2)
3. Execute the parsed statement
4. Return an "OK" to the client
Are you using the sequence
sqlite3_prepare_v2(), sqlite3_step(), sqlite3_finalize()
for each statement ? If not you are asking your program to do a lot of extra
memory handling.
Alternatively you could just use sqlite3_exec(), which does all three of the
above things.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
