Hello, I'm sysop on the french Wikipedia. I want to run a SQL request to change all "Egypte", "egypte" and "égypte" to "Égypte" (french name for Egypt) on the body articles of the french data base. (I will make the titles rename by hand) Someone are against that ? What request do you advise ? Regards, Aoineko PS : I consider that "who say nothing agree", so if I have no comment since last week I will run my request (of course I will send the command line first).

Il y en a vraiment beaucoup d'article a faire... N'y a t'il pas des plages horraires pas trop encombre ? Je suis pres a faire tourner la requete a n'importe quel heure de ton choix. Si je fait une recherche avec l'outil de recherche sur "Egypte antique" puis "egypte antique" et enfin "égypte antique", ca me parait plus lourd que une seul requete qui cherche les trois et les remplacent par "Égypte antique". Je me trompe ? Tu penses vraiment que c'est une requete lourde ? Si tu as peur que j'abime la base avec une erreure de requete, je prefere que tu me le dise franchement ;o) Merci pour la reponse. Aoineko

Ils dorment a quel heure UTC ? :oP Aoineko

On Mon, Apr 28, 2003 at 06:28:06PM +0200, Thomas Corell wrote: No, it's ok to write in any language. Especially apropriate are multilingual posts.

oups, copy&past error :o) here is the right version: UPDATE LOW_PRIORITY cur SET cur_text = REPLACE( cur_text, ' foo1 ', ' foo2 ') WHERE cur_text LIKE '% foo1 %'; Aoineko

to Thomas Corell : international Sorry but I just answered Tarquin who has the kindness to answer my english question in my native language. to Tomasz Wegrzanowski : Thanks, I will try to post in english (or both). to Jason Richey : If we download the "current" french database each time we want to run a query (to get the last updated entry) it is heavy, isn't it ? We only discuss the better time to run a query according to the americans sleeping time ;o) By the way I didn't get the answer yet, what is the best time to run queries (not especially this one) ? It perhaps not the right time to speak about query since you have so much performence problems ! To be continued... (later) Aoineko

On Mon, 2003-04-28 at 03:30, Erik Moeller wrote: I have only very rarely seen slowdowns caused by sysops making SQL queries, whereas the special pages and the search cause much more continuous states of slowness as they are constantly pounded on. Becuase they don't happen in isolation; there are a lot of searches. -- brion vibber (brion @ pobox.com)