[email protected]] On Behalf Of Max Vlasov
Sent: Sunday, December 26, 2010 07:27 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Searchtime in SQL
On Sun, Dec 26, 2010 at 12:51 PM, Randolph Dohm
wrote:
> Hello
>
> we develop a bookmark database for urls, http://
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 :
>
>
> 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 t
On Sun, Dec 26, 2010 at 12:51 PM, Randolph Dohm 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 s
>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
On Sun, 26 Dec 2010 10:51:07 +0100, Randolph Dohm
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
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
6 matches
Mail list logo
