I have 168mb sqlite database in sdcard containing nearly 30 tables each with more than 1000 records. i am using this query to fetch results from database.
select code mfr_code, name mfr_name
where mfgr_type_code <5and code in(
This query is taking more than 30 seconds in curve 5.0 and more than 1minute in torch 6.0 devices.
The subquery "SELECT mfgr_code FROM equipment_groups" is fetching more than 50k records.
same query when test in android is taking lessthan 5 seconds. What is the problem with blackberry.
Is there any way other way to reduce this processing time.