Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: Disable case-sensetive search on cyryllic site
Here are some poor benchmarks :) My tests told, that total sql growing time would be about 1,15%.Here are options and docs from static analise:
- Site was tested at local web server, 800mhz Intel.
- Textpattern table has 14 records, total size is 48.74 KB
- was made 6-8 measures, if value of sql1-2 time was more than +20% from avg, measure was remeasured :)
- Google docs excel with counts
- Source Microsoft Excel xls file
- Page’s output with full tagtrace
Was performed this patch for publish.php
publish.php (appr. line 635):
- $cols[$i] = "`$cols[$i]` rlike '$q'";
+ $cols[$i] = "lower(`$cols[$i]`) rlike lower('$q')";
Last edited by the_ghost (2009-03-24 11:30:29)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Disable case-sensetive search on cyryllic site
Is this test worth to be think as honest? Case-insensetive search without pathces\plugins for russian (and i think other languages) i very good for Textpattern.
Last edited by the_ghost (2009-07-11 07:06:14)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline