[pLog-svn] db optimization

Christoph Feddersen feddersen at herr-der-ringe-film.de
Sun Apr 2 09:24:15 GMT 2006


Jon Daley wrote:
> I turned on slow query logging, and no-index queries.

Can you send me the slow query log aswell as the logfile that contains
all mysql queries?


> The context has tons of these: SELECT/UPDATE pairs.
<snip>
> I made a post earlier, and I think there are two SQL queries for each
> word I typed: 708 SQL queries in 2 seconds.
Well, that should be optimized. Is that filter working with ajax? It
seems to make a request and database query after typing in a new character?

Christoph


More information about the pLog-svn mailing list