{"id":3397,"date":"2017-10-12T13:13:01","date_gmt":"2017-10-12T05:13:01","guid":{"rendered":"https:\/\/www.bytebot.net\/blog\/?p=3397"},"modified":"2017-10-12T13:13:01","modified_gmt":"2017-10-12T05:13:01","slug":"not-all-cloud-instances-are-created-equal","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal","title":{"rendered":"Not all cloud instances are created equal"},"content":{"rendered":"<p>You know how anecdotally we say, &#8220;in the cloud, bad nodes exist&#8221; so you should always get a baseline? <\/p>\n<p>Today I ran a query (repeatedly) on <code>sqlite3<\/code>, and on two instances, I got time measured as:<\/p>\n<pre><code>Run Time: real 13.405 user 13.243332 sys 0.046667\nRun Time: real 10.989 user 10.963332 sys 0.010000\n<\/code><\/pre>\n<p>This naturally skewed results I initially got for something related to MySQL\/MariaDB benchmarking. It really was such that while I had 2 instances, in the same region\/AZ, I had one &#8220;good&#8221; node and one &#8220;bad&#8221; node.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You know how anecdotally we say, &#8220;in the cloud, bad nodes exist&#8221; so you should always get a baseline? Today I ran a query (repeatedly) on sqlite3, and on two instances, I got time measured as: Run Time: real 13.405 user 13.243332 sys 0.046667 Run Time: real 10.989 user 10.963332 sys 0.010000 This naturally skewed [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1503],"tags":[1911,353,1910],"class_list":["post-3397","post","type-post","status-publish","format-standard","hentry","category-tech","tag-benchmarking","tag-cloud","tag-sqlite3"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-SN","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"amp_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=3397"}],"version-history":[{"count":1,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3397\/revisions"}],"predecessor-version":[{"id":3398,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3397\/revisions\/3398"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=3397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=3397"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=3397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}