Re: [sqlite] Making Update fast

souvik.datta wrote: > Update set Flag=1 where Filename=; Check index presence on Filename column and still make updates in 1 large transaction. - Best Regards. Max Kosenko. -- View this message in context: http://www.nabble.com/Making-Update-fast-tp25269409p25273296.html Sent from the

Re: [sqlite] Making Update fast

Did you tried using the pragmas refer sqlite documentation for pragmas http://www.sqlite.org/pragma.html Atul souvik.datta wrote: > > > > Update set Flag=1 where Filename=; > > The updates taking huge amount of time. I tried to wrap these updates > within transactions (50 updates

[sqlite] Making Update fast

Hello, I am having a table which contains meta data of some Mp3 files. The table may contain 6000 to 7000 records. Every time a device is inserted, I am reading the device and based on a logic, I update a column value - from 0 to 1. This needs to be done for every record that are there in the