Yes, it will definitely help if you maintain a list of the top orders without have to query for it each time. You just have to be wary of transactional issues - I'd suggest using Task Queues for eventual consistency.
On Mon, Apr 26, 2010 at 7:40 AM, Pk <[email protected]> wrote: > I am storing a big list of order information in datastore. I have an > order entity which has certain properties related to the order. I have > a property called IsProcessed on the order entity. Once I process the > order, I make it as true. I do not have entity groups, transactions > etc., (not necessary in my case, actually). now, I have a page which > displays a list of orders which are not processed. I only need to show > the first 100 orders that are not processed yet(order by DATE desc). > So I want to select the 100 orders and show it to the user, and it has > to be high performing as well. Now, the question is, if I have another > set of entity which only has processed order, and if an order is > processed, instead of changing the boolean property, if I simply move > it to different entity and delete the old one, will it help in > performance, while selecting the top 100 orders that are not > processed? Over a course of time, there could be million order > entities. Any help would be appreciated. > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine for Java" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]<google-appengine-java%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-appengine-java?hl=en. > > -- Ikai Lan Developer Relations, Google App Engine Twitter: http://twitter.com/ikai Delicious: http://delicious.com/ikailan ---------------- Google App Engine links: Blog: http://googleappengine.blogspot.com Twitter: http://twitter.com/app_engine Reddit: http://www.reddit.com/r/appengine -- You received this message because you are subscribed to the Google Groups "Google App Engine for Java" 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-java?hl=en.
