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 SQ
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 within
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
3 matches
Mail list logo