sql - Inner join order by performance issue in Android 2.3 -
i have used sql select query in android app works fine on newer versions of android i.e takes 30 40 seconds on samsung galaxy tab( android 4.0.3) retreive data sqlite database, on device older version of android 2.3 takes 18 minutes retreive data. if remove "order x_unitperson.unitseq" performance not decreases on android 2.3. how can increase performance on android 2.3 without removing order clause. my sql is: select person_id, commander, citizen, rank, given, surname, isor, (select group_concat(name_short, '\n') units inner join (select * x_unitperson person_id = people.person_id order x_unitperson.unitseq) xunits units.unit_id = xunits.unit_id) name_short, (select fname photos person_id = people.person_id) fname people order surname, given i not familiar sqlite optimiser, if correlated subquery rewritten join optimisers create same execution plan both que...