[Devel] Patch - LCR Strip Option

Juha Heinanen jh at tutpro.com
Tue Dec 6 12:14:52 CET 2005


Bogdan-Andrei Iancu writes:

 > "SELECT %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s, %.*s.%.*s 
 > FROM %.*s, %.*s WHERE '%.*s' LIKE %.*s.%.*s AND '%.*s' LIKE 
 > CONCAT(%.*s.%.*s, '%%') AND %.*s.%.*s = %.*s.%.*s ORDER BY 
 > CHAR_LENGTH(%.*s.%.*s), %.*s.%.*s DESC, RAND()"
 > 
 > I would say the patch makes sense only if it solves completely the 
 > problem....

yes, and the real solution is to avoid the db query altogether and write
the code in c.  this can be done by first extending reload_gws() to load
also the routes to memory and then by rewriting load_gws() so that it
uses in-memory information only.

-- juha



More information about the Devel mailing list