Hello Nathan, Thursday, July 12, 2007, 4:30:13 PM, you wrote:
NB> I have been trying see just how fast I can get SQlite to run, so I have NB> been playing with binding data to pre-compiled statements versus having NB> to prepare each statement individually. So far, I have not seen a huge NB> performance increase between the two. I expected the pre-compiled NB> statements to be much faster. When I ran the test, I used a simple NB> insert statement with just 4 variables. Will you only see a big NB> performance difference if the statement is more complicated? NB> ----------------------------------------------------------------------------- NB> To unsubscribe, send email to [EMAIL PROTECTED] NB> ----------------------------------------------------------------------------- I use binding not so much for the performance though, I like that too. I just find it's far less error prone then trying to generate properly escaped SQL in a string and then execing it. Can't really work with blobs without using Binding too. I'd use it even if there was no performance benefit. -- Best regards, Teg mailto:[EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
