N.B. Queries with LIKE will not use an index if the particular implementation of SQLite overrides LIKE. The .NET implementation I'm familiar with has done so; the OP's may have done so too. However, GLOB was left intact and does make use of an index on "starts with" and "equals" substring searches.
GLOB is case-sensitive. select * from products where description GLOB 'shirt*' Note the asterisk wildcard instead of the percent-symbol. Regards Tim Romano Swarthmore PA Regards Tim Romano On Tue, May 11, 2010 at 5:50 AM, Pavel Ivanov <paiva...@gmail.com> wrote: > > Sometimes search found 200 records. When I do a query via wi-fi takes 1 > > minute. > > How can I decrease this time? > > Time taken to search for the records does not depend on how many > records found. It depends on how many records were searched through. > Most probably for your query no indexes are used, so the whole table > is scanned through. And that means that the whole database is copied > to your device via WiFi, which apparently is slow. > > To decrease the amount of data transfered to the device you can use > indexes. For this particular query you can create index like this: > > CREATE INDEX Product_Ind on Product > (description COLLATE NOCASE); > > > Pavel > > On Mon, May 10, 2010 at 6:31 PM, Ernany <ernan...@gmail.com> wrote: > > Hello, > > > > I'll try to explain my problem: > > > > I have a Symbol MC3090 Data Collector with VB.Net 2005. I have a database > > with 80,000 records on the computer. > > > > For example: I search all words that begin with "shirt" and show in the > Grid > > Collector. > > Sometimes search found 200 records. When I do a query via wi-fi takes 1 > > minute. > > How can I decrease this time? > > > > On the computer the same search takes a few seconds ... > > > > > > Public ConnStringDados As String = "Data Source=" & Address & "\" & > NameDB > > & ";Version=3;Compress=True;Synchronous=Off;Cache Size=8000;" > > > > > > My select: > > > > "SELECT codigo, description FROM Product WHERE description Like '" & Word > > _Search & "%'" > > > > > > Thanks, > > > > Ernany > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
