*** 240,243 **** --- 240,249 ---- Now SQlite doesn't have to read the value and just puts the number 1 in the result row so you know there are appointments at 5. This is mostly usable when you for example give an overview of a day and have to indicate on what hours there are appointments. Personally I used this on a not so powerful embedded system, so it will be not so noticable on a PC platform of course. + <H2>Prepared statements must be generated inside your transaction</H2> + + <p>Entered by Nathan P Sharp, Jan 2008</p> + + <p>While trying to improve the performance of bulk imports in our C++ project, we found that creating the prepared statements was a large hit. Creating them once at the construction of our class, though, made the problem worse! It turns out that prepared statements that are generated before the transaction start do not work with the transaction. The fix was simply to create new prepared statements once per transaction.</p> + </html>
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|