On 2010 Feb 13, at 13:51, daniele malcom wrote:
> Hi Roland, in fact indices table exists (for DDArticle entity):
> Enter SQL statements terminated with a ";"
> sqlite> .tables
> ZDDARTICLE Z_METADATA Z_PRIMARYKEY
> sqlite> .indices ZDDARTICLE
> ZDDARTICLE_ZMESSAGEID_INDEX
> ZDDARTICLE_ZPARENT_INDEX
>
> With my macbook pro insertion of 30k articles took about 2/3 minutes.
> I've uploaded a test project:
> http://dl.dropbox.com/u/103260/CoreDataTreeTest.zip
> I really don't know why it should take this long time but using
> Instruments the big part is obviously fetch for searching id and
> parent.
Sorry, I've not downloaded your project yet.
If you're using garbage collection, ignore this. If not, in your previous
code, I noticed there was a memory leak in using -newArticleWithID:.
Another silly idea, just for fun, would be to create that predicate in code. I
just don't like -predicateWithFormat:. Something like this (untested code):
NSExpression* lhs = [NSExpression expressionForKeyPath:@"messageid"] ;
NSExpression* rhs = [NSExpression expressionForConstantValue:_msgid];
NSPredicate *predicate ;
predicate = [NSComparisonPredicate predicateWithLeftExpression:lhs
rightExpression:rhs
modifier:NSDirectPredicateModifier
type:NSEqualToPredicateOperatorType
options:0] ;
For some real evil, run that query using the sqlite command-line program and
see how long it takes :0
_______________________________________________
Cocoa-dev mailing list (Cocoa-dev@lists.apple.com)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/cocoa-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
