Hi, Apologies for the confusion by query I meant the whole loop of creating a connection, querying and then closing the connection. It was something I noticed on an old IIS server mainly with php pages where the connection loop would happen quite a lot as you navigated pages.
The only time I've known this affect Riv were a few messages to the mailing group complaining about pressing the add button in airplay caused noticeable delays. Regards, Wayne On 16/05/13 15:17, Brian McKelvey wrote: > This would suggest that each query from Rivendell opens a new TCP connection > to MySQL, which would be bizarre behavior. Is that really how it works? I > don't think MySQL does a reverse DNS lookup for every client query, just for > each connection. And I doubt that's default behavior to do reverse DNS > lookups at all in modern distros, but I'll have to look into that. > > Brian > > Sent from my iPhone > > On May 16, 2013, at 4:51 AM, Wayne Merricks <[email protected]> > wrote: > >> This delay happens every time the >> remote machine sends a query so even if MySQL completes the query in >> 100ms you'll have that 3+ second delay tacked on top. > _______________________________________________ > Rivendell-dev mailing list > [email protected] > http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev _______________________________________________ Rivendell-dev mailing list [email protected] http://lists.rivendellaudio.org/mailman/listinfo/rivendell-dev
