Is this on your first request after an update, or on all requests? During your first request, your application has to be "spun up", and this consumes about the amount of CPU time you described for a simple Java application. The entity looks simple enough that it shouldn't take that long if it's not an initial request.
On Sun, Dec 13, 2009 at 2:29 AM, S nathan <[email protected]> wrote: > 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]<google-appengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > > > -- Ikai Lan Developer Programs Engineer, Google App Engine -- 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.
