just a little up since I have had no answers?
I'm still having the pb and cannot understand why? :)
Dennis Cote a écrit :
>
> I am forwarding this to the list in the hope that someone else will
> have a good idea since the OP, toms, is having trouble posting himself.
>
> Dennis Cote
>
> toms wrot
(juste a test sorry)
Dennis Cote a écrit :
>
> I am forwarding this to the list in the hope that someone else will
> have a good idea since the OP, toms, is having trouble posting himself.
>
> Dennis Cote
>
> toms wrote:
>> ok here is the code I use for the statements:
>>
>> here is the SQL:
>>
I am forwarding this to the list in the hope that someone else will have
a good idea since the OP, toms, is having trouble posting himself.
Dennis Cote
toms wrote:
> ok here is the code I use for the statements:
>
> here is the SQL:
>
> "UPDATE Statistics_Players"
> " SET "
> " i
Bruce Robertson wrote:
> Thanks, but I'm gonna need some further instruction or examples or pointers
> to a resource as none of these statements mean anything to me.
>
I also posted some sample code that is equivalent to the old sample code
at http://www.sqlite.org/quickstart.html which still us
Bruce Robertson wrote:
> Thanks, but I'm gonna need some further instruction or examples or pointers
> to a resource as none of these statements mean anything to me.
>
Try reading this http://www.sqlite.org/cintro.html and see if it makes
more sense after that.
HTH
Dennis Cote
_
On Mon, Jun 09, 2008 at 03:39:01PM -0700, Bruce Robertson scratched on the wall:
> Thanks, but I'm gonna need some further instruction or examples or pointers
> to a resource as none of these statements mean anything to me.
These are C API function calls. If you're not using the C API, none
o
Thanks, but I'm gonna need some further instruction or examples or pointers
to a resource as none of these statements mean anything to me.
> Use this sequence:
>
> sqlite3_open
> sqlite3_prepare_v2//Compiles SQL statement
>
> loop
> sqlite3_bind... //Binds variables
>
> sqlite
Use this sequence:
sqlite3_open
sqlite3_prepare_v2//Compiles SQL statement
loop
sqlite3_bind... //Binds variables
sqlite3_step//Executes statement
sqlite3_reset //Readies compiled statement for binding to vars
until finished
sqlite3_finalize
Can somebody point me to documentation or examples of sqlite prepare
statements and their purose?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> I would expect that sqlite3_prepare would be faster in such a case, and
> maybe Toms is pointing out a circumstance where recreating the query
> seems to be faster. Or am I misreading the post?
One possible explanation (stab in the dark):
If many of the bound parameters are text (or blob) ba
Chiming in a thought, but isn't there a subtle difference between the two?
As I am reading Toms post, sqlite3_prepare would be called once and the
parameters would be bound up to 384 times
The call to sqlite3_exec should finalize the prepared query and
re-prepare it 384 times.
I would expect t
Sqlite3_exec just encapsulates sqlite3_prepare. You very likely have
something wrong with your code if yor version works slower.
toms wrote:
> Hi all
> I tried to use the sqlite3_prepare to increase my performances during
> requests for both writing / reading.
> The strange thing is that when u
Hi all
I tried to use the sqlite3_prepare to increase my performances during
requests for both writing / reading.
The strange thing is that when using prepare on a request used many
times with many parameters (many times = 384 max, many parameters = 15)
it os slower than simply using the sqlite3
13 matches
Mail list logo