On Tue, Nov 8, 2011 at 4:37 PM, Alberto Valaz <[email protected]>wrote:
> 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.
>
>
--
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.
