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.
On Sat, Dec 23, 2017 at 11:32 AM John <[email protected]> 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 < > [email protected]> wrote: > >> You *can* join them, but not by using database logic. You must join them >> in your application. >> >> Martin >> >> so 23. 12. 2017 v 19:03 odesÃlatel Maximilian Doerr < >> [email protected]> napsal: >> >>> Ah. >>> >>> Cyberpower678 >>> English Wikipedia Account Creation Team >>> English Wikipedia Administrator >>> Global User Renamer >>> >>> On Dec 23, 2017, at 12:58, John <[email protected]> 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 < >>> [email protected]> wrote: >>> >>>> So users can no longer create their own DBs now? Or am I missing >>>> something? >>>> >>>> Cyberpower678 >>>> English Wikipedia Account Creation Team >>>> English Wikipedia Administrator >>>> Global User Renamer >>>> >>>> On Dec 23, 2017, at 12:44, Martin Domdey <[email protected]> wrote: >>>> >>>> Hi Maarten! >>>> >>>> I didn't got it by -announce, but I need it too in close future. >>>> >>>> Cheers, >>>> Martin ... >>>> >>>> >>>> -- >>>> Diese Nachricht wurde von meinem Android Mobiltelefon mit GMX Mail >>>> gesendet. >>>> Am 23.12.2017, 14:29, Maarten Dammers <[email protected]> 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 >>>>> [email protected] (formerly [email protected]) >>>>> https://lists.wikimedia.org/mailman/listinfo/cloud >>>> >>>> _______________________________________________ >>>> Wikimedia Cloud Services mailing list >>>> [email protected] (formerly [email protected]) >>>> https://lists.wikimedia.org/mailman/listinfo/cloud >>>> >>>> >>>> _______________________________________________ >>>> Wikimedia Cloud Services mailing list >>>> [email protected] (formerly [email protected]) >>>> https://lists.wikimedia.org/mailman/listinfo/cloud >>>> >>> >>> _______________________________________________ >>> Wikimedia Cloud Services mailing list >>> [email protected] (formerly [email protected]) >>> https://lists.wikimedia.org/mailman/listinfo/cloud >>> >>> >>> _______________________________________________ >>> Wikimedia Cloud Services mailing list >>> [email protected] (formerly [email protected]) >>> https://lists.wikimedia.org/mailman/listinfo/cloud >> >> >> _______________________________________________ >> Wikimedia Cloud Services mailing list >> [email protected] (formerly [email protected]) >> https://lists.wikimedia.org/mailman/listinfo/cloud >> > > _______________________________________________ > Wikimedia Cloud Services mailing list > [email protected] (formerly [email protected]) > https://lists.wikimedia.org/mailman/listinfo/cloud
_______________________________________________ Wikimedia Cloud Services mailing list [email protected] (formerly [email protected]) https://lists.wikimedia.org/mailman/listinfo/cloud
