iphone - Sqlite + 80K rows + LIKE = keyboard lag -


I have a problem that I am resolving, but now is the time.

I have a basic dictionary program, it has a UISearchBar and a UITableView. This is due to the keyboard lag while running on the device except by the way it works. (The simulator is okay, of course) I have two types of searches: As-you-type and on-return I think that taking both of the same amount of time to return results, but as you type keyboard Make intervals of

I have a UISearchBar text dead change that takes search text and sends it to a search method, raises all the escalation, puts the result in an array, the table is reloaded. 

  - (zero) search bar: (UISearchBar *) Search Bert Text Did Change: (NSString *) search text {if ((search type == SEARCH_AS_YOU_TYPE) & amp; amp; ([[ Search text length] & gt; = 2)) {NSString * myKeyword = [NSString stringWithFormat: @ "% @", search text]; [Self search: myKeyword]; [MyTableViewReload Data]; }}

I limit the results to 50. And I like the use of my SQL query and or, there is no way to it yet. 

  SELECT WORD_ID, DEFIN, PINYIN, SIMP, TRAD, where defined by DEFIN "% to dog%" or DEFIN such as "% dog" or DEFIN "% dog%" DEFIN LIMIT < / Code>

I also tried to move [myTableView reloadData] into the search method, hopefully the keyboard will not have minimal interval. no joy. And unfortunately I know that SQLite is basically checking every line, when it uses the same operator but 3-4 seconds for 80 hours seem a bit slow.

Any thoughts, ideas, comments or suggestions will be highly appreciated!

I think that you are searching and preparing the keyboard in the same thread. The more times you search this way, the more you will have letters and typing speed will be limited to the speed of the search.

An appropriate solution is different in two threads, the second one to search and display search results to read one and display the keyboard. In this way, if you can search, you are typing fast, only the search interval, but not typing. For example, the Firefox address bar works like this.

Due to communication / coordination between the two threads and the two, your code will become more complex, but I think that this is the only good solution.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more