On Sun, Dec 26, 2010 at 12:51 PM, Randolph Dohm <[email protected]>wrote:
> Hello > > we develop a bookmark database for urls, http://arado.sf.net and used > SQLite with Qt. > With 7000 database entries of urls the search for a keyword takes up > to 15 seconds to respond. > That is quite a long time, why is SQL so slow? is there a way to > improve the speed besides to switch to another database or to develop > an own TXT file on the harddisk? > Randolph, I looked at your schema in the sources and a query that formed in SearchAny method. Maybe there's something you can do with this to improve the speed, but believe me, the best you can do is to move toward full-text search (compile your qt sqlite adapter fts3/fts4 enabled). Just imagine a dedicated user of your application in ten years, he never deleted urls, only added and every month he or she feels that the search becomes slower and slower. With full-text search you have to do something very special to make it really slow. Max Vlasov _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
