{"id":6135,"date":"2018-01-19T19:35:25","date_gmt":"2018-01-19T19:35:25","guid":{"rendered":"http:\/\/goofy-trucks.flywheelsites.com\/optimizing-sql-queries\/"},"modified":"2018-01-19T19:36:14","modified_gmt":"2018-01-19T19:36:14","slug":"optimizing-sql-queries","status":"publish","type":"post","link":"https:\/\/phpbuilder.com\/optimizing-sql-queries\/","title":{"rendered":"Optimizing SQL queries"},"content":{"rendered":"<div class=\"phpbuilder-content\">\n<div class=\"phpbuilder-meta\">\n<div class=\"\">By Tom Copeland<\/div>\n<div class=\"\">on April 21, 2004<\/div>\n<\/p><\/div>\n<div id=\"overflow-content\">\n<p>I&#8217;ve written a little article on optimizing SQL queries:<\/p>\n<p><a href=\"http:\/\/www.databasejournal.com\/features\/postgresql\/article.php\/3323561\" target=\"_blank\">http:\/\/www.databasejournal.com\/features\/postgresql\/article.php\/3323561<\/a> <\/p>\n<p>using a utility called PQA:<\/p>\n<p><a href=\"http:\/\/pqa.rubyforge.org\/\" target=\"_blank\">http:\/\/pqa.rubyforge.org\/<\/a><\/p>\n<p>I&#8217;ve used PQA to help improve some of the SQL in the popular GForge (<a href=\"http:\/\/gforge.org\/\" target=\"_blank\">http:\/\/gforge.org\/<\/a>) project.  Hope you find it helpful!<\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve written a little article on optimizing SQL<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-6135","post","type-post","status-publish","format-standard","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/comments?post=6135"}],"version-history":[{"count":1,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6135\/revisions"}],"predecessor-version":[{"id":6960,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/posts\/6135\/revisions\/6960"}],"wp:attachment":[{"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/media?parent=6135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/categories?post=6135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/phpbuilder.com\/wp-json\/wp\/v2\/tags?post=6135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}