> 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
