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 slow it down. There is a method, unfortunately not available is Sqlite, called a Stored Procedure. A Stored Procedure is especially useful in your case because you move the database access from the Symbol to a more powerful computer, and reduce the back and forth WiFi traffic. The SQL would be sent from the Symbol to the computer hosting the database, the query would executed on the host computer and the result sent back to the Symbol. If possible, a workaround or emulation of a Stored Procedure could be done. You could send the SQL to a program on the host, and that program would interrogate the database and return the result. It would need a reasonable level of skill to implement. regards, Kevin _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users