{"id":98,"date":"2017-04-05T10:48:29","date_gmt":"2017-04-05T10:48:29","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=98"},"modified":"2017-04-11T08:13:37","modified_gmt":"2017-04-11T08:13:37","slug":"how-fast-is-db-doc","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2017\/04\/05\/how-fast-is-db-doc\/","title":{"rendered":"How fast is DB Doc"},"content":{"rendered":"<p><a href=\"http:\/\/www.yohz.com\/dbdoc_details.htm\">DB Doc<\/a> is our PostgreSQL database schema documentation tool, and we recently had the opportunity to work on a fairly large production database. \u00a0The database had 7 schemas, containing over 800 tables, over 17000 columns in total, 300+ sequences, and 350+ functions. \u00a0DB Doc was ran on the server with a single Intel I5 3 GHz CPU, and the disks were consumer-grade SATA disks.<\/p>\n<p>To read the entire database schema, DB Doc took 15 seconds. \u00a0To generate the HTML documentation, which comprised over 1600 HTML pages, took 7 seconds.<\/p>\n<p><span style=\"font-size: 18pt;\"><em>7 seconds!<\/em><\/span><\/p>\n<p>That means it took DB Doc less than 30 seconds to read the database schema and generate a 1600 page HTML report documenting that database.<\/p>\n<p>To generate a PDF report that contained almost 11000 pages took 3 minutes 45 seconds.<\/p>\n<p><em><span style=\"font-size: 18pt;\">11000 pages in 3 minutes 45 seconds!<\/span><\/em><\/p>\n<p>Understandably, we are very proud of what we have achieved with DB Doc. \u00a0If you have a PostgreSQL database that DB Doc seems to be having problems documenting, please do drop us a line at <a href=\"mailto:support@yohz.com\">support@yohz.com<\/a>. \u00a0We&#8217;re pumped to improve on the above numbers even further!<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2017\/04\/05\/how-fast-is-db-doc\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2017\/04\/05\/how-fast-is-db-doc\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>DB Doc is our PostgreSQL database schema documentation tool, and we recently had the opportunity to work on a fairly large production database. \u00a0The database had 7 schemas, containing over 800 tables, over 17000 columns in total, 300+ sequences, and 350+ functions. \u00a0DB Doc was ran on the server with a single Intel I5 3 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6],"tags":[3],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/98"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=98"}],"version-history":[{"count":2,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/98\/revisions"}],"predecessor-version":[{"id":106,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/98\/revisions\/106"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=98"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=98"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=98"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}