#1442 ManyToOne::Relationship#get is much slower in DM 1.0.2 v.s. DM 0.10.0 - DataMapper

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

#1442 unconfirmed

ManyToOne::Relationship#get is much slower in DM 1.0.2 v.s. DM 0.10.0

Reported by Alexander Sorokin | November 2nd, 2010 @ 04:23 PM

In DM 1.0.2, ManyToOne::Relationship#get takes 3.4 seconds per 515 calls. DM 0.10.0 takes 0.11 seconds per 400 calls.
This slows down validation that happens when an object is created.

It goes down to Query#initialize that is around 4 times slower in DM 1.0.

screen-shot-2010-11-02-at-123719-pm.png 26.2 KB
screen-shot-2010-11-02-at-123706-pm.png 22.4 KB
screen-shot-2010-11-02-at-53145-am.png 12.7 KB
dm-010-queryinitialize.png 64.7 KB
dm-10-queryinitialize.png 55.2 KB

Comments and changes to this ticket

Martin Gamsjaeger (snusnu) November 4th, 2010 @ 06:02 AM
- State changed from “new” to “unconfirmed”
- Tag set to “performance, regression”
You flagged this item as spam.
Alexander Sorokin November 8th, 2010 @ 07:55 PM
Let me know, what are the next steps on this ticket. If you need more specific examples from me, let me know. Afaik our upgrade to DM 1.0.* is blocked on this and #1443. I'd love to have some sort of a timeline for this issue.
Xavier Shay December 2nd, 2010 @ 11:25 PM
Alex, a standalone benchmark script would be helpful. Here is one you can use as a template: https://gist.github.com/716295
You flagged this item as spam.
Alexander Sorokin January 5th, 2011 @ 05:59 PM
Here's a script with get:
https://gist.github.com/767260

The difference on get isn't as pronounced as with create, but still pretty significant.

Xavier Shay January 9th, 2011 @ 05:28 PM

As per #1443, I haven't got a 0.10 env yet, but saw a big diff between 1.8 and 1.9.

== 1.0.2
1.9:
  1.620000   0.080000   1.700000 (  2.238703)
  2.140000   0.080000   2.220000 (  2.661571)

1.8:
  2.540000   0.110000   2.650000 (  3.192656)
  3.250000   0.120000   3.370000 (  3.800239)

You flagged this item as spam.
Alexander Sorokin January 10th, 2011 @ 02:22 PM
As in #1443

== DM 0.10, ruby 1.9

0.570000 0.050000 0.620000 ( 1.476753)
1.170000 0.050000 1.220000 ( 1.569268)

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.