so everytime an order is marked as processed, I move it to another list and delete from original? I'll hve two lists. one is processed and another is unprocessed. kind of like horizontal partitioning. do you think it will help while reading the top 100 orders order by date descending from one list, instead of reading from one big list which has both processed and unprocessed orders? - just checking my understanding.
On Apr 30, 2:34 am, "Ikai L (Google)" <[email protected]> wrote: > 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 > athttp://groups.google.com/group/google-appengine-java?hl=en. -- 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.
