Thanks Max and Jean, FTS3 seems to be a solution. Do you wanna join to compile for FTS3 and optimize the SQLite database of Arado?
2010/12/26 Max Vlasov <[email protected]>: > > > 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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
