Just a thought... Wouldn't it be less load on the server if someone were to download the fr database dump, run a query on their local machine to figure out what entries need updated, then run several specific queries on the live database to update the appropriate entries?
This way, we could avoid the full text matching on "%whatever%" to discover which entries need updating.
Please forgive me if my SQL knowledge is lacking, or if a solution has already been found during discussion in French... I'd love to read (in English) what was said in the French discussion of this thread, if anyone cares to translate...
Jason Richey
tarquin wrote:
Guillaume Blanchard wrote:
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)
non non c'est pas ca! mais j'ai l'impression que le serveur rame pour un rien en ce moment. Mais je ne suis pas developeur, c'est juste ce que j'entends sur cette liste. Les plages peu encombrees: quand les Americains dorment!!!
Wikitech-l mailing list Wikitech-l@wikipedia.org http://www.wikipedia.org/mailman/listinfo/wikitech-l