I noticed that a number of simple SQL operations that my application
is dependent on generate very high quota usage.
Basically, one run of the three operations listed below are enough to
use up my daily free quota!!
I assume I am doing something very wrong but I am not sure how to fix
it. Could anyone please give me
thank you
PS. an interesting twist is that the below code worked just fine under
the old payment model.
---------------------
// The table Something below has around 50k rows. No indexes are used.
PersistenceManager pm = ...
// Select COUNT(*) from Something
Query q = pm.newQuery(Something.Class, null);
q.setResult("count(this)");
q.execute();
// select COUNT(*) from Something where 1234 > feild
Query q = pm.newQuery(Something.Class, "this.field > field");
q.declareParameters("Long field");
q.setResult("count(this)");
q.executeWithArray(1234);
// select * from Something order total DESC
Query q = pm.newQuery(Something.Class, null);
q.setOrdering("total DESC");
q.execute();
--
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.
