iphone - sqlite Indexing Performance Advice -
I have a SQLT database in my iPhone app that I use through core data structures to query the database I am using NSPddicates for
I am creating a search function for which there is a need to search in six different increment fields that contain text. At the moment, it is very slow and Need to improve, s Bwat: Sclait create an index on what all the columns in the database would be best? Or would it be better to create a custom index table that spreads those six columns into several rows, which would have a match with each word and ID? any other suggestions?
There are things that you can improve the search performance of text in the SQLite database. Although the original data is removed from the built-in store, however, it is good to appreciate it when your shop is being used while using SQLite.
If we believe that you are searching a substring of these areas, then there are things that you can do to improve search performance. Apple recommends using a derived asset . It is used for searching in your model to maintain a normalized version of your property, the derived asset should be done in such a way that it can be indexed. After this you will see binary operator> & lt; Using the = etc to express its search in relation to this derived asset.
I am finding that it reduces our search by 100 millimeters from approximately 1 second.
To clarify things, I see the ADC example
Comments
Post a Comment