I think you'll see the biggest difference when you run the same statement many times with different bound variables (vs recompiling each time).
Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: Nathan Biggs [mailto:[EMAIL PROTECTED] Sent: Thursday, July 12, 2007 4:30 PM To: SQLITE Subject: [sqlite] Binding vs No Binding I have been trying see just how fast I can get SQlite to run, so I have been playing with binding data to pre-compiled statements versus having to prepare each statement individually. So far, I have not seen a huge performance increase between the two. I expected the pre-compiled statements to be much faster. When I ran the test, I used a simple insert statement with just 4 variables. Will you only see a big performance difference if the statement is more complicated? ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
