08-18-2011 11:38 AM
Solved! Go to Solution.
08-18-2011 12:48 PM
1) Check in your select statmente which field are you sing in the Where/OrderBy clauses
2) Use your favourite SQLite manager and crete indexes in the table where you wanto to isuue a SELECT
3) To Prepare your statements use wildcard holders if you want to execute a query in a loop, and just use Bind to pass the parameters