1341290135

Android 7.0 System

The code is relatively complex, and it is not clear enough to take it out alone. There is indeed a retrieval index field. I would like to ask, is the...

Sir， //Class
 @entity
 public class SongItemAllNew extends SAbstractItemNew{ @id
 public long lngKey; @Index public String strSongName; @Index public String strSongPinYin; @Index public int bytSongWordCount; public String strMediaFilePath; .... } //Query
...

[Your primary order is bytSongWordCount, correct?] Yes [Also what is the typical distribution of bytSongWordCount?] The value range is about 0-15 Thanks a lot

Sir， Change and test as you said： //Query
 QueryBuilder queryBuilder = songItemAllNewBox.query(); 
queryBuilder .equal(SongItemAllNew_.bytSongWordCount, 1) 
.order(SongItemAllNew_.strSongPinYin)
 .order(SongItemAllNew_.strSongName); //Find 
GlobleValues.printRuningTimeDurStop(TAG + "(" + "doInBackground BEFORE query" + ")"); //time begin listQuery...

Thank you sir， Just like this： strSongName / strSongPinYin / bytSongWordCount Unchained melody /UM /2 My heart will go on /MHWGO /5 Yesterday once more /YOM /3 All songs total...

Thank you very much, I'll try as you suggest.

Sir, About 2) have an artificial property for a search key (e.g. bytSongWordCount plus first character of strSongPinYin). I had test in this way, the entire database is divided into...

Sir, The searchKey look like : 1A // corresponding some songs bytSongWordCount ==1 and strSongPinYin with A 1B // corresponding some songs bytSongWordCount ==1 and strSongPinYin with B ... n)...

Yes, in actual tests, I used （ i