re: Core Data Performance

FROM : Ben Trumbull
DATE : Thu Jan 24 02:01:36 2008

Keith,

>I have customers who created their databases under Tiger and others
>who created their databases under Leopard.  So if the user is using
>Leopard AND it is an old Tiger database (without subtype indexes) then
>I want to tell the user how to get the performance improvements
>available on Leopard - in my case dump an reload the data. Some
>customers only have small databases or do not make heavy use of these
>indexes so they will not be told anything.


There isn't a great way to do this.  The officially supported way
would be for your application to add a key to the store metadata for
your own use, and upgrade the first time (when the key is absent).

The unsupported way would be to use a NSTask (etc) to launch a shell
script that used the sqlite3 tool to do whatever.  In this case to
query for the index, or just attempt to create the index.

Might be worth an enhancement request ...
--

-Ben