• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Core Data: different fetch performance when launching app
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Core Data: different fetch performance when launching app


  • Subject: Core Data: different fetch performance when launching app
  • From: Diederik Hoogenboom <email@hidden>
  • Date: Fri, 13 Oct 2006 13:17:53 +0200

I have a Core Data app. When I run the app the first time after a reboot it takes a long time (20 seconds) to launch. When I restart the application the launch time is reduced to 2 seconds.

When | enable sqldebug I see the following:


First launch:

CoreData: sql: SELECT S.Z_ENT, S.Z_PK, S.Z_OPT, S.ZCOMMENTTEXT, S.ZICONDATA, S.ZCREATIONDATE, S.ZTOTALBYTES, S.ZLASTMODIFIEDDATE, S.ZFOLDERCOUNT, S.ZFILECOUNT, S.ZISPACKAGE, S.ZFULLPATH, S.ZNAME, S.ZUUID, S.ZISCONTAINER, S.ZPARENT, S.Z4_PARENT, S.ZCATEGORY, S.ZREMOVABLE, S.ZLOCATION, S.ZMEDIATYPEDESCRIPTION, S.ZFILESYSTEMTYPENAME, S.ZFREEBYTES, S.ZWRITABLE, S.ZKIND, S.ZFILETYPECODE, S.ZCREATORCODE, S.ZCREATOR, S.ZFILEATTRIBUTES, S.ZUTI, S.ZGROUP, S.ZINARCHIVE, S.ZPARTOFCATALOG FROM ZSTORAGEITEM S WHERE S.Z_ENT = ? ORDER BY S.ZNAME

CoreData: annotation: fetch execution time: 12.439718s


Launching the application a second time:

CoreData: sql: SELECT S.Z_ENT, S.Z_PK, S.Z_OPT, S.ZCOMMENTTEXT, S.ZICONDATA, S.ZCREATIONDATE, S.ZTOTALBYTES, S.ZLASTMODIFIEDDATE, S.ZFOLDERCOUNT, S.ZFILECOUNT, S.ZISPACKAGE, S.ZFULLPATH, S.ZNAME, S.ZUUID, S.ZISCONTAINER, S.ZPARENT, S.Z4_PARENT, S.ZCATEGORY, S.ZREMOVABLE, S.ZLOCATION, S.ZMEDIATYPEDESCRIPTION, S.ZFILESYSTEMTYPENAME, S.ZFREEBYTES, S.ZWRITABLE, S.ZKIND, S.ZFILETYPECODE, S.ZCREATORCODE, S.ZCREATOR, S.ZFILEATTRIBUTES, S.ZUTI, S.ZGROUP, S.ZINARCHIVE, S.ZPARTOFCATALOG FROM ZSTORAGEITEM S WHERE S.Z_ENT = ? ORDER BY S.ZNAME

CoreData: annotation: fetch execution time: 0.161268s


I use a SQLLite persistent store.

Is this normal behavior? It looks like Core Data caches the fetch/ data for the current login session.


Diederik _______________________________________________ Do not post admin requests to the list. They will be ignored. Cocoa-dev mailing list (email@hidden) Help/Unsubscribe/Update your Subscription: This email sent to email@hidden
  • Follow-Ups:
    • Re: Core Data: different fetch performance when launching app
      • From: Diederik Hoogenboom <email@hidden>
    • Re: Core Data: different fetch performance when launching app
      • From: Jakob Olesen <email@hidden>
  • Prev by Date: Where to find free EULA Templates?
  • Next by Date: Re: Where to find free EULA Templates?
  • Previous by thread: [Moderator] EOT (Re: Where to find free EULA Templates?)
  • Next by thread: Re: Core Data: different fetch performance when launching app
  • Index(es):
    • Date
    • Thread