• 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
Re: Core Data: different fetch performance when launching app
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Core Data: different fetch performance when launching app


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

Do you guys think batch faulting can help here?

Diederik

On 13-okt-2006, at 13:17, Diederik Hoogenboom wrote:

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:
40obviousmatter.com


This email sent to email@hidden

_______________________________________________ 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
References: 
 >Core Data: different fetch performance when launching app (From: Diederik Hoogenboom <email@hidden>)

  • Prev by Date: Re: Tracking frontmost App
  • Next by Date: Flip an NSBitmapImageRep
  • Previous by thread: Re: Core Data: different fetch performance when launching app [SOLVED]
  • Next by thread: Cannot compile, Volume name changed
  • Index(es):
    • Date
    • Thread