Ikai, Thank you for your reply. I did a test where I issued 10 requests. The number I got was - 868 (46) 100%. Like you mentioned the initial request is what consumes more CPU time and the numbers go down for subsequent requests. Also, (with apologies for asking a naive question) could you please explain how I read these numbers. I can see 868 seconds is the CPU time but what does the number 46 denote? Thanks again, Nathan
On Tue, Dec 15, 2009 at 4:50 AM, Ikai L (Google) <[email protected]> wrote: > 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]<google-appengine%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > -- 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.
