Emany,
this has possibly already been done, but have you got an index on the table
for the column called "description"?
I would suggest a timed test on both the Symbol device and the computer
before and after the index is added.
Also, the Symbol may only have 64Mb of RAM, which probably would sl
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.
> 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 use
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
4 matches
Mail list logo