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
