maria-docs team mailing list archive

[Sergei Petrunia <psergey@xxxxxxxxxxxx>]

Hello,

For a long time, search on KB felt very slow for me. Today I'm reporting it.
Please look at times for some searches below:

psergey@pslp2:~$ time wget -O /dev/null 'https://mariadb.com/kb/en/+search/?q=partition&quick=1&search=Search'
...
real	0m3.981s
user	0m0.048s
sys	0m0.000s
psergey@pslp2:~$ time wget -O /dev/null 'https://mariadb.com/kb/en/+search/?q=no_such_term_for_sure&quick=1&search=Search'
...
real	0m1.001s
user	0m0.060s
sys	0m0.004s

psergey@pslp2:~$ time wget -O /dev/null 'https://mariadb.com/kb/en/+search/?q=explain&quick=1&search=Search'
...
real	0m10.807s
user	0m0.044s
sys	0m0.004s

psergey@pslp2:~$ time wget -O /dev/null 'https://mariadb.com/kb/en/+search/?q=another_unknown_term&quick=1&search=Search'
...
real	0m1.009s
user	0m0.056s
sys	0m0.004s

A non-search is also not too fast:

psergey@pslp2:~$ time wget -O /dev/null 'https://mariadb.com/kb/en/explain-in-the-slow-query-log/'
...
real	0m1.576s
user	0m0.056s
sys	0m0.004s

but search queries are worse, they can take 4 to 10 seconds.  Can we do
something about this?

For comparison:

psergey@pslp2:~$ time wget -O /dev/null 'http://www.percona.com/search?s=join'
...
real    0m0.567s
user    0m0.004s
sys     0m0.004s

psergey@pslp2:~$ time wget -O /dev/null 'http://www.postgresql.org/search/?u=%2Fdocs%2F9.3%2F&q=create+table'
...
real    0m0.959s
user    0m0.004s
sys     0m0.004s



BR
 Sergei
-- 
Sergei Petrunia, Software Developer
MariaDB | Skype: sergefp | Blog: http://s.petrunia.net/blog