Did you tried using the pragmas .... refer sqlite documentation for pragmas http://www.sqlite.org/pragma.html Atul
souvik.datta wrote: > > > > Update <tableName> set Flag=1 where Filename=<FileName>; > > The updates taking huge amount of time. I tried to wrap these updates > within transactions (50 updates within one transaction) but that is > actually causing the a Read thread (the one which is trying to read the > Metadata info ) to starve. > If I am not using the transaction , the read thread response is much > better but then the updates are running real slow. > > Can some suggest how I can improve this? > > Thanks and Regards, > Souvik > > Please do not print this email unless it is absolutely necessary. > > The information contained in this electronic message and any attachments > to this message are intended for the exclusive use of the addressee(s) and > may contain proprietary, confidential or privileged information. If you > are not the intended recipient, you should not disseminate, distribute or > copy this e-mail. Please notify the sender immediately and destroy all > copies of this message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient > should check this email and any attachments for the presence of viruses. > The company accepts no liability for any damage caused by any virus > transmitted by this email. > > www.wipro.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/Making-Update-fast-tp25269409p25271497.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users