I am new to appengine and so pardon my ignorance. I have created a
simple application on app engine. My datatable has 14 fields. For a
simple select all query (my database just has 4 records) app engine
warns about the URI consuming a high amount of CPU and that it may
soon exceed its quota.
I can see in the appengine console that the Average CPU time for a
select all query is 7139 (69) - First off, it would be great if
someone explain how I read this number. I understand 7139 is the
number of CPU seconds. What is the number in brackets? How do I
improve the performance? Should I decrease the number of fields. I
have created indexes for possible queries.
While searching the forum I did come across a similar issue for
someone who had just 6 fields in the data model but the answer was not
conclusive as to why such a simple query hogs so much CPU time. Should
I reduce the number of fields?
Any help would be greatly appreciated.
My data model if its of any help
@Persistent(valueStrategy = IdGeneratorStrategy.IDENTITY)
private Long id;
@Persistent
private String emptype;
@Persistent
private String empField1;
@Persistent
private String empId;
@Persistent
private String details;
@Persistent
private String city;
@Persistent
private String country;
@Persistent
private String contactname;
@Persistent
private String contactnumber;
@Persistent
private Date dateofjoin;
@Persistent
private String empField2;
@Persistent
private long salary;
@Persistent
private String empField3;
@Persistent
private String empField4;
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en.
