And the performance bottleneck is... localhost?!

While troubleshooting performance for a Fakoli website (one of the few production sites we have running on IIS under Windows) I was concerned to find that connecting to the database was taking over a second. Previously this had not been a performance issue, so why were things slow now?

Trawling through StackOverflow, I found a reply to a similar problem indicating that it seems that PDO is drastically slower making database connections to a local database if the database hostname is given as "localhost" rather than using the raw IP address "127.0.0.1". I made this change and lo, the connection times went down to less than 0.01 seconds. This has a huge performance impact on a Fakoli site, since images and other assets are often served dynamically.

This performance problem seems to be related to PHP 5.4 and later - the same site performed fine back when it was on PHP 5.3. Anyhow, be warned - localhost may be stealing your performance!

By Andy Green, posted on Tuesday September 10, 2013
PHP, MySQL, PDO

Comments

  • xrob jljbpccjgbwh
    Posted by lcgqjxoqnpbu at 2014-12-30 16:28:43
    From that moment on, i fell in love with the city, with the town of a person, often in a book, a breeze, into a curtain, see a plain white woman, holding an oil-paper umbrella, walking in the bluestone alley, leaving a graceful back shadow, or is in a patch of sunlight, as if thinking of sth. cheap wholesale canada goose reviews for horrible bosses canada goose montebello parka priceline coupon Through the support of his friends and his family and his wife he decided to transition to living as a woman and have the surgeries and went through the whole process but didn't have that wardrobe and didn't know how to shop for clothes, said Kressley, who visits each town with a brightly painted Airstream camper in tow. canada goose vest outlet store canada goose freestyle patagonia down vest Ahora con T Galleria de Hysan Place, hemos llevado el lujo al siguiente nivel, creando un nuevo destino fresco e imaginativo donde viaje y compras se encuentran, dijo Benjamin Vuchot, director administrativo de DFS Group para el Norte de Asia. canada goose yves rocher canada online store canada goose hybridge lite hoody price In connection with this national fundraising initiative benefiting Komen, Premium Outlets is proud to support Komen, and with the help of generous customers, will guarantee a contribution of at least $100,000. canada goose expedition parka uk stockist Everyone fell silent, everything is attributed to calm. canada goose vest outlet store canada goose montebello sale Have a look again summing up other people love the cartesian coordinate system, the abscissa direction is to believe in love, the negative direction is not believe love, y-coordinate direction is striven for actively, negative orientation is a passive acceptance of so also have the first, two, three, four quadrant, respectively, is love without fear, realism, where there is love, lover not full! buy canada goose jackets cheap canada goose kensington parka deutschland Give yourself a chance, maybe you can go together. antique canada goose decoys canada goose parka pictures Girls school uniforms in his every kind of printing t-shirts, boys wore short sleeves come swaggeringly cool through. canada goose outlet sverige qvpjhfoo http://www.abacoflyfish.com/Canada-Goose-Mountaineer-Jackets/Canada-Goose-canada-goose-parka-pictures-site-705.asp btkcpwyj
  • fkpx qpinpkcphlvl
    Posted by tvvhivumifmb at 2014-12-26 14:47:24
    I am very painful, but you can be so carefree and content, placid. valentino bag for sale new designer for valentino Jess Lee, CEO of the fashionfocused Pinterest rival Polyvore, says, Ecommerce 1. valentino shoe prices valentino bridal dresses I look at my wardrobe and shudder to think what I would have paid if I didn't get most of my stuff for 2540 cents on the dollar. isabel marantz e-shop gr greece valentino sposa for pronovias Can swim with a sealion but want 45 per person and 12 for a picture. valentino garavani clothing style Come to a certain place, a very strange voice suddenly told me. buy online designer clothes 6pm shoes online I once read in books: a view of a scholar, his mental development influences the style, always after forty years old, will usher in the real creation peak. valentino espadrille wedge hottest fashion designers 2014 oscars I shook my head, back to him, let the breeze blowing gently skirt, said i have my own plan to eyes glassy looked out the window, looking at the crowd like streams of people busily coming and going, the whole world is only left over me as if ,returned to my small garden, a boy lying on the window for me. valentino garavani handbags 2013 valentino shoes saks fifth avenue I think it is two words, i know i vulgar, a boy should not use &ldquo beauty ;to describe, but then visualize is beautiful two words. luxury baby clothing online store ribjqmhg http://www.selpeco.com/valentino-purses/Shopstyle-valentino-scarf-black-Share-528.Html dmgsgiob