We upgraded to appengine-java-sdk 1.2.5 today (from 1.2.2) and the
performance seems to
be back to what we were experiencing earlier which was well under a
second for 100 entities.
We're not sure why but the performance when we were using 1.2.2 was
similar to not specifying
the one to one owned fields as lazy loading.
Len
On Sep 22, 10:42 am, lent <lentakeu...@gmail.com> wrote:
> Hello,
>
> We are using JPA and the retrieval of one of our kinds seems to be
> quite slow at about 3-4 seconds per 100 in production. The entities
> of this kind are not in the same entity group. We have made some
> adjustments to the kind recently which may have caused the slow down.
> The persistent class definition is as below. We used to have a blob
> field for content which we have moved to a separate class
> (ContentValue) and created OneToOne owned relationship with (we used
> to have one blob for content but now we have 2 ContentValue fields).
> Two of our fields used to be String but now has been converted to
> List<String> fields. We have added a OneToMany owned relationship to
> another class. We seemed to recall performance used to be better
> prior to some of these adjustments. Is the performance we're seeing
> reasonable?
>
> The query we issue is as follows with the number of results capped at
> 100 using setMaxResult on the query in JPA:
> select c from Contributor c where id > someId
>
> From the retrieved query result, we do not access the two ContentValue
> fields or the ContactCollection list. Some datanucleus debug output
> is also at the bottom.
>
> Any insights into the performance would be appreciated.
>
> Regards,
> Len
>
> @Entity
> public class Contributor {
> @Id
> @GeneratedValue(strategy=GenerationType.IDENTITY)
> @Extension(vendorName="datanucleus", key="gae.encoded-pk",
> value="true")
> private String id;
>
> @Enumerated
> @Extension(vendorName="datanucleus", key="gae.parent-pk",
> value="true")
> private String userId;
>
> @Enumerated
> private String firstName;
>
> @Enumerated
> private String lastName;
>
> @Enumerated
> private String title;
>
> @Enumerated
> private String division;
>
> @OneToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY )
> private ContentValue picture;
>
> @OneToOne(cascade = CascadeType.ALL, fetch = FetchType.LAZY )
> private ContentValue thumbnailPicture;
>
> @OneToMany(cascade = CascadeType.ALL)
> private List<ContactCollection> collections = new
> ArrayList<ContactCollection>();
>
> @Enumerated
> private String bio;
>
> @Enumerated
> private List<String> skills;
>
> @Enumerated
> private List<String> qualifications;
>
> @Enumerated
> private Date birthDate;
>
> @Enumerated
> private String workEmail;
>
> @Enumerated
> private String workOfficePhone;
>
> @Enumerated
> private String workMobilePhone;
>
> @Enumerated
> private String personalEmail;
>
> @Enumerated
> private String homePhone;
>
> @Enumerated
> private String personalMobilePhone;
>
> // accessors
> ...
>
> }
>
> DataNucleus Debug Output:
> ----------------------------------------
> D 09-21 04:36PM 34.665
> org.datanucleus.ObjectManagerImpl getObjectFromCache: Object with id
> "com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGN87DAsSC0NvbnRyaWJ1dG9yGAEM"
> not found in Level 1 cache [cache size = 0]
> D 09-21 04:36PM 34.667
> org.datanucleus.ObjectManagerImpl getObjectFromCache: Object with id
> "com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGN87DAsSC0NvbnRyaWJ1dG9yGAEM"
> not found in Level 1 cache [cache size = 0]
> D 09-21 04:36PM 34.667
> org.datanucleus.ObjectManagerImpl putObjectIntoCache: Object
> "com.jostleme.jostle.server.domain.contribu...@12c4d93"
> (id="com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGN87DAsSC0NvbnRyaWJ1dG9yGAEM")
> added to Level 1 cache (loadedFlags="[NNNNNNNYNNNNNNNNNNNNNNNNNN]")
> D 09-21 04:36PM 34.766
> org.datanucleus.sco.backed.List <init>: Object
> "com.jostleme.jostle.server.domain.contribu...@12c4d93" field
> "collections" is replaced by a SCO wrapper of type
> "org.datanucleus.sco.backed.List" [cache-values=true, lazy-
> loading=true, queued-operations=true, allow-nulls=false]
> D 09-21 04:36PM 34.773
> org.datanucleus.ObjectManagerImpl getObjectFromCache: Object with id
> "com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGOA7DAsSC0NvbnRyaWJ1dG9yGAEM"
> not found in Level 1 cache [cache size = 1]
> D 09-21 04:36PM 34.773
> org.datanucleus.ObjectManagerImpl getObjectFromCache: Object with id
> "com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGOA7DAsSC0NvbnRyaWJ1dG9yGAEM"
> not found in Level 1 cache [cache size = 1]
> D 09-21 04:36PM 34.774
> org.datanucleus.ObjectManagerImpl putObjectIntoCache: Object
> "com.jostleme.jostle.server.domain.contribu...@1845cce"
> (id="com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGOA7DAsSC0NvbnRyaWJ1dG9yGAEM")
> added to Level 1 cache (loadedFlags="[NNNNNNNYNNNNNNNNNNNNNNNNNN]")
> D 09-21 04:36PM 34.805
> org.datanucleus.sco.backed.List <init>: Object
> "com.jostleme.jostle.server.domain.contribu...@1845cce" field
> "collections" is replaced by a SCO wrapper of type
> "org.datanucleus.sco.backed.List" [cache-values=true, lazy-
> loading=true, queued-operations=true, allow-nulls=false]
> D 09-21 04:36PM 34.806
> org.datanucleus.ObjectManagerImpl getObjectFromCache: Object with id
> "com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGOE7DAsSC0NvbnRyaWJ1dG9yGAEM"
> not found in Level 1 cache [cache size = 2]
> D 09-21 04:36PM 34.806
> org.datanucleus.ObjectManagerImpl getObjectFromCache: Object with id
> "com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGOE7DAsSC0NvbnRyaWJ1dG9yGAEM"
> not found in Level 1 cache [cache size = 2]
> D 09-21 04:36PM 34.806
> org.datanucleus.ObjectManagerImpl putObjectIntoCache: Object
> "com.jostleme.jostle.server.domain.contribu...@c4ef1"
> (id="com.jostleme.jostle.server.domain.Contributor:agpzaGFxYmFtYnUzchwLEgRVc2VyGOE7DAsSC0NvbnRyaWJ1dG9yGAEM")
> added to Level 1 cache (loadedFlags="[NNNNNNNYNNNNNNNNNNNNNNNNNN]")
> D 09-21 04:36PM 34.836
> org.datanucleus.sco.backed.List <init>: Object
> "com.jostleme.jostle.server.domain.contribu...@c4ef1" field
> "collections" is replaced by a SCO wrapper of type
> "org.datanucleus.sco.backed.List" [cache-values=true, lazy-
> loading=true, queued-operations=true, allow-nulls=false]
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine for Java" group.
To post to this group, send email to google-appengine-java@googlegroups.com
To unsubscribe from this group, send email to
google-appengine-java+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine-java?hl=en
-~----------~----~----~----~------~----~------~--~---
