{"id":3304,"date":"2017-05-23T18:10:10","date_gmt":"2017-05-23T16:10:10","guid":{"rendered":"https:\/\/geekosas.com\/?p=3304"},"modified":"2026-05-23T18:10:29","modified_gmt":"2026-05-23T16:10:29","slug":"r-vs-ms-open-r-2","status":"publish","type":"post","link":"https:\/\/geekosas.com\/index.php\/2017\/05\/23\/r-vs-ms-open-r-2\/","title":{"rendered":"R vs MS open R"},"content":{"rendered":"

Microsoft has realized the power of R, so it has integrated it into its systems, including Power BI and SQL Server 2017. Microsoft released a free version of R with some improvements, including native SQL Server connection, package versioning in MRAN (Microsoft Cran), and optimizations in the linear algebra package.<\/p>\n

This last one claims to be considerably faster than the one included in R, so following the line of the Article on Sparse Matrix<\/a>, I ran some tests.<\/p>\n

In the following tests, the performance of R 3.4.2 (32 and 64-bit) and Microsoft Open R 3.4.1 was compared using R’s standard matrices:<\/p>\n

 
\nTime to perform a Linear Regression<\/strong><\/p>\n

\"\"<\/p>\n

Time to perform a Logistic Regression<\/strong><\/p>\n

\"\"<\/p>\n

Time to square the matrix.<\/strong><\/p>\n

\"\"<\/p>\n

Time to invert the matrix<\/strong><\/p>\n

\"\"<\/p>\n

Time to perform SVD decomposition<\/strong><\/p>\n

\"\"<\/p>\n

As you can see, Microsoft’s R wins in all tests. Additionally, you can have both R versions installed on your PC, so it doesn’t hurt to try it.<\/p>\n","protected":false},"excerpt":{"rendered":"

Microsoft has realized the power of R, so it has integrated it into its systems, including Power BI and SQL Server 2017. Microsoft released a […]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":2222,"comment_status":"open","ping_status":"open","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_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":[1],"tags":[],"class_list":["post-3304","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sin-categoria"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2017\/10\/ClarkHead.990fbedf.png?fit=140%2C118&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p8vjqF-Ri","jetpack-related-posts":[{"id":3223,"url":"https:\/\/geekosas.com\/index.php\/2020\/05\/14\/insert-records-into-the-database-at-full-speed\/","url_meta":{"origin":3304,"position":0},"title":"Insert Records into the Database at Full Speed","author":"Daniel Fischer","date":"2020-05-14","format":false,"excerpt":"ETL tools are very useful for performing automated and recurring data transformation processes; they are characterized by performing three tasks: (E) Extract: Connect to one or more sources and extract data. (T) Transform: Transform or manipulate the data. (L) Load: Load the transformed data into the final repository. That is\u2026","rel":"","context":"In "Sin categor\u00eda"","block_context":{"text":"Sin categor\u00eda","link":"https:\/\/geekosas.com\/index.php\/category\/sin-categoria\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2021\/09\/patch.png?fit=728%2C380&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2021\/09\/patch.png?fit=728%2C380&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2021\/09\/patch.png?fit=728%2C380&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2021\/09\/patch.png?fit=728%2C380&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3337,"url":"https:\/\/geekosas.com\/index.php\/2019\/05\/23\/r-and-super-powerful-pcs\/","url_meta":{"origin":3304,"position":1},"title":"R and super-powerful PCs","author":"Daniel Fischer","date":"2019-05-23","format":false,"excerpt":"R and Python are very popular lately, but have you asked yourself if you are getting the most out of these languages? In fact, you probably have a super\u2011powerful PC to work with them. Well, the truth is that if you are entering the world of Analytics, you might not\u2026","rel":"","context":"In "Sin categor\u00eda"","block_context":{"text":"Sin categor\u00eda","link":"https:\/\/geekosas.com\/index.php\/category\/sin-categoria\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2019\/02\/2922898-a.jpg?fit=350%2C350&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3296,"url":"https:\/\/geekosas.com\/index.php\/2017\/05\/23\/i-will-teach-an-r-course\/","url_meta":{"origin":3304,"position":2},"title":"I will teach an R course.","author":"Daniel Fischer","date":"2017-05-23","format":false,"excerpt":"The course will be at Microsoft Chile on September 22: The R Intensive is an event designed for those who have data analysis and modeling needs in their work and want to gain in 1 day the theoretical and practical knowledge to start solving their analytical challenges with this tool.\u2026","rel":"","context":"In "Sin categor\u00eda"","block_context":{"text":"Sin categor\u00eda","link":"https:\/\/geekosas.com\/index.php\/category\/sin-categoria\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2016\/11\/RStudio-Ball.png?fit=1000%2C1000&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2016\/11\/RStudio-Ball.png?fit=1000%2C1000&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2016\/11\/RStudio-Ball.png?fit=1000%2C1000&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2016\/11\/RStudio-Ball.png?fit=1000%2C1000&ssl=1&resize=700%2C400 2x"},"classes":[]},{"id":3311,"url":"https:\/\/geekosas.com\/index.php\/2017\/05\/23\/step-forward-attribute-selection-in-r\/","url_meta":{"origin":3304,"position":3},"title":"Step Forward Attribute Selection in R","author":"Daniel Fischer","date":"2017-05-23","format":false,"excerpt":"I made a video in English that explains how to program a step forward attribute selection for linear regressions in R. https:\/\/www.youtube.com\/watch?v=P5ufV7ZqTUk&feature=youtu.be \u00a0","rel":"","context":"In "Sin categor\u00eda"","block_context":{"text":"Sin categor\u00eda","link":"https:\/\/geekosas.com\/index.php\/category\/sin-categoria\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2017\/11\/400px-Linear_regression.svg_.png?fit=400%2C265&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3300,"url":"https:\/\/geekosas.com\/index.php\/2017\/05\/23\/data-science-course-in-r\/","url_meta":{"origin":3304,"position":4},"title":"Data Science course in R","author":"Daniel Fischer","date":"2017-05-23","format":false,"excerpt":"On October 20, I will teach a Data Science course using R. The topics covered will be: Data Cleaning Supervised classification models: Logistic regression. Naive Bayes. Trees and Random Forest. Neural Networks. Grid Search (hyperparameter tuning). Evaluation of classification models. Unsupervised models: Dimensionality Reduction (PCA) -> Applied example of replicating\u2026","rel":"","context":"In "Sin categor\u00eda"","block_context":{"text":"Sin categor\u00eda","link":"https:\/\/geekosas.com\/index.php\/category\/sin-categoria\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2017\/09\/Rprogramming.jpg?fit=1176%2C664&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2017\/09\/Rprogramming.jpg?fit=1176%2C664&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2017\/09\/Rprogramming.jpg?fit=1176%2C664&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2017\/09\/Rprogramming.jpg?fit=1176%2C664&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2017\/09\/Rprogramming.jpg?fit=1176%2C664&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":3326,"url":"https:\/\/geekosas.com\/index.php\/2018\/05\/23\/write-in-aws-redshift-at-fill-speed\/","url_meta":{"origin":3304,"position":5},"title":"Write in AWS Redshift at Fill Speed!","author":"Daniel Fischer","date":"2018-05-23","format":false,"excerpt":"As many know, Redshift is a fork of Postgres made by Amazon to provide a Data Warehouse service. The big difference between these two products is that the former is a columnar and compressed database, while the latter is not. Columnar databases are very fast for aggregations and joins, but\u2026","rel":"","context":"In "Sin categor\u00eda"","block_context":{"text":"Sin categor\u00eda","link":"https:\/\/geekosas.com\/index.php\/category\/sin-categoria\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2018\/08\/RtoRedshift.png?fit=600%2C300&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2018\/08\/RtoRedshift.png?fit=600%2C300&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/geekosas.com\/wp-content\/uploads\/2018\/08\/RtoRedshift.png?fit=600%2C300&ssl=1&resize=525%2C300 1.5x"},"classes":[]}],"_links":{"self":[{"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/posts\/3304","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/comments?post=3304"}],"version-history":[{"count":1,"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/posts\/3304\/revisions"}],"predecessor-version":[{"id":3305,"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/posts\/3304\/revisions\/3305"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/media\/2222"}],"wp:attachment":[{"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/media?parent=3304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/categories?post=3304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/geekosas.com\/index.php\/wp-json\/wp\/v2\/tags?post=3304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}