SQlite update time

[ancle]

I used sqlite api to update my data, my array is  7x30. It takes 1.5s, is any methods can improve speed? Thank you!

 

B/R

Ancle

[LogMAN]

Use a prepared statement and a transaction. Your current implementation requires writing for each iteration which is slow obviously. Check out the "Insert many rows code template" on the SQLite Library >> Code Templates palette. The prepared statement will allow you to use binding which is very useful as it maintains data types in your application. See following Picture for an example (I can't test it right now, but it should work like that):

[ancle]

Hi LogMAN,

 

Thanks for your tips. I modified my code as attached image. It takes 200ms.

B/R

Ancle

[LogMAN]

Way better

Still you perform many write operations by executing the SQL in a loop without a transaction. The more values you have, the slower your loop becomes. Your current implementation might result in incomplete data in case of SQL errors (you can't undo your actions)! Try to add a transaction around your loop (It's very easy to do, costs nothing and is at least worth a try):

Transactions will prevent file-writes for as long as they are not committed (this is why it might save you some more time). By calling the Commit VI at the end, all data will be written in one go. In case of errors you can just reverse everything by doing a rollback (The Commit VI will do a rollback on error automatically).

Edited May 4, 2016 by LogMAN
Rollback is done automatically by the Commit VI

[ancle]

Hi LogMAN,

Thanks again. After added two vis, it takes 30ms. 

B/R

Ancle