On Sun, 26 Dec 2010 10:51:07 +0100, 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? It is certainly possible to make it faster. Mozilla Firefox uses SQLite for the same purpose. You may want to study their code to see how they do it. -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
