Re: CoreData - large data set is slow to load on app launch - optimisation tips?
Re: CoreData - large data set is slow to load on app launch - optimisation tips?
- Subject: Re: CoreData - large data set is slow to load on app launch - optimisation tips?
- From: Simon Liu <email@hidden>
- Date: Sat, 3 Dec 2005 19:57:53 +0000
The image data is around 62MB. When I removed it from my main entity,
the sql store was reduced from 80MB to 18MB and loaded in around 2
seconds on launching the app. A dramatic improvement.
Yes, currently the image data is an attribute of an entity. It was an
oversight. I'm going to make it into a relationship to see how that
improves things. The rest of the data model is pretty lean.
I wonder if the coredata folk can tell me if its a good idea to have
data blobs like images all stored in a separate data store or not? If
the image data is a 1:1 relationship will performance be the same with
1 data store versus 2 (or more?). I want my app to be able to handle
upto around 50,000 records and images. The store size would probably
be around 800 MB in all.
On 12/3/05, Ruslan Zasukhin <email@hidden> wrote:
>
On 12/3/05 7:01 PM, "Simon Liu" <email@hidden> wrote:
>
>
> Hi,
>
>
>
> My app's single SQL store contains over 5,000 instances of an entity,
>
> each with an associated image (jpeg data). There are also other
>
> entities, relationships, etc. The SQL store comes in at around 80MB.
>
>
More...
>
>
May be this will help.
>
>
Where you keep images?
>
>
If you keep them in the same table this can explain.
>
Try put images into separate table and link them to main table as 1:1
>
>
>
--
>
Best regards,
>
>
Ruslan Zasukhin
>
VP Engineering and New Technology
>
Paradigma Software, Inc
>
>
Valentina - Joining Worlds of Information
>
http://www.paradigmasoft.com
>
>
[I feel the need: the need for speed]
>
>
>
_______________________________________________
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