"Farzana" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > The query we used is "SELECT * FROM Brand ORDER BY BrandDescription". > The Brand table contains more than 30,000 records. The execution time > is reasonable when we execute in the system.But it is slower when we > execute the same in the device.
And do you have reasons to expect the query to run faster on the device? Does the device have a faster CPU, or faster I/O, than your development system? Because otherwise I don't quite see why you would be surprised by this outcome. Double-check that you have actually created the index in the copy of the database that's sitting on the device. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users