>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?
Your question can't be answered anyway without you providing the SQLite version you use, your schema, the query used and if possible a handful of example rows of the offending table(s). The context (multi-user, multi-thread, network, OS, ...) may also be relevant. Are you using FTS3 to dissect/lookup keywords, or are you using something else? _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
