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]. For more options, visit this group at http://groups.google.com/group/google-appengine-java?hl=en.
