Am 23.12.2017, 19:48, Daniel Schwen <li...@schwen.de> schrieb:
Suggesting that joins be just done in the application logic is frankly quite naive. I have one particular application where I need to join millions of entries each on about 50 projects. I used to have an application join algorithm years ago, when the data sets were much smaller and I supported way fewer projects. It was a disaster back then with extremely long run times and frequent failures (when serves went away etc.). It doesn't scale up. On-server joins increased the performance by orders of magnitude. I won't be able to go back to the old way. It sucks. Nobody is as sad about this as I am. I feel like the floor is put away under my feet and under my creation._______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloudOn Sat, Dec 23, 2017 at 11:32 AM John <phoenixoverr...@gmail.com> wrote:That's not a join. Doing it in the application layer means that both database tables must be fully loaded into RAM to process. Please do not call them the same thing as an application layer "JOIN" and a database join are far from the same thing._______________________________________________On Sat, Dec 23, 2017 at 1:27 PM, Martin Urbanec <martin.urba...@wikimedia.cz> wrote:You can join them, but not by using database logic. You must join them in your application.Martinso 23. 12. 2017 v 19:03 odesílatel Maximilian Doerr <maximilian.do...@gmail.com> napsal:Ah.Cyberpower678
English Wikipedia Account Creation Team
English Wikipedia AdministratorGlobal User Renamer_______________________________________________On Dec 23, 2017, at 12:58, John <phoenixoverr...@gmail.com> wrote:You can create user databases, however those are hosted on a different server than the replicas, and we cannot join them._______________________________________________On Sat, Dec 23, 2017 at 12:55 PM, Maximilian Doerr <maximilian.do...@gmail.com> wrote:So users can no longer create their own DBs now? Or am I missing something?Cyberpower678English Wikipedia Account Creation TeamEnglish Wikipedia AdministratorGlobal User RenamerAm 23.12.2017, 14:29, Maarten Dammers <maar...@mdammers.nl> schrieb:Hi everyone,
In the new database setup user databases are no longer possible on the
same servers as where the production databases are. I noticed on
https://phabricator.wikimedia.org/T142807 Daniel saying "Death blow for
GHEL coordinate extraction and WikiMiniAtlas." and on
https://phabricator.wikimedia.org/T183066 several tools broke down.
Do we have an overview of tools that are now broken? Did the database
admins actually contact the tool maintainers about the loss of
functionality or was this just send to the -announce list?
Maarten
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
Wikimedia Cloud Services mailing list
Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list Cloud@lists.wikimedia.org (formerly lab...@lists.wikimedia.org) https://lists.wikimedia.org/mailman/listinfo/cloud