Lars Aronsson lars-at-aronsson.se |wikipedia| wrote:
You can still store a copy of each text (cur) in the database, and use that for searching. The vast amount of I/O over the database client-server socket is when every page view has to read the blob from the database to the (PHP) application, through the socket where the bandwidth might be limited.
Can you elaborate on how performance problems caused by slow sockets may manifest themselves? I executed the following query, which extract 17 MB of blobs in 1.5 seconds (on a slow computer). Are you perhaps referring to the general slowness added by retrieving data over network connections instead of using local files?
$ time echo "SELECT cur_text FROM cur"|mysql wikidb >/dev/null real 0m1.449s user 0m0.990s sys 0m0.130s
//E23