It seems your code-base has grown into a quite huge monolithic app. If you haven't done yet, you might look into this: Microservices Architecture on Google App Engine <https://cloud.google.com/appengine/docs/standard/java/microservices-on-app-engine>. You could expand your app by putting new models / handlers into new apps using this pattern, and eventually also use a different storage product for them. It also depends on your existing app and the roadmap, how well you can separate the new parts without refactoring the old app.
You cannot do a transaction across Cloud Datastore and Cloud SQL or Cloud Spanner. You also should keep in mind that every product comes with different advantages and disadvantages and you need to figure out which trade-offs make most sense for your technical and business requirements. Considering a mature app that has to cover many different use-cases, maybe you will pick more than one storage product to meet all of them. And although I don't know if that's the case here, worth to mention: I often have seen a (composite) index used in Datastore only for user-facing searches where Search API would have made much more sense. Refactoring such cases can be quite easy if your app is the only client writing into its GCD. Good luck! On Sunday, May 13, 2018 at 9:45:56 AM UTC+2, Rajesh Gupta wrote: > > Hi, > We are running out of indexes on appengine datastore. We have 10-20 > remaining. > No time for doing refactoring and to regain the indexes. > > One thought is to use Cloud sql or Cloud spanner for further development. > There are other reasons also to look for alternatives to datastore. > (finding talent, restrictions of datastore on aggregates queries, no easy > way to do migrations or schema changes) > > Is there a way to do a transaction across datastore and cloud sql or cloud > spanner > > What are the recommended methods to further expand dev. > > Rajesh > *www.GainERP.com <https://www.gainerp.com>* > *ERP & Field Service on Google Cloud* > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To unsubscribe from this group and stop receiving emails from it, send an email to google-appengine+unsubscr...@googlegroups.com. To post to this group, send email to google-appengine@googlegroups.com. Visit this group at https://groups.google.com/group/google-appengine. To view this discussion on the web visit https://groups.google.com/d/msgid/google-appengine/4bce3e58-b220-4783-8971-7d2f821b947f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
