ABOUT CLICKBENCH
In ClickBench, the test data are all taken from the actual traffic recording of one of the world’s largest web analytics platforms, covering a variety of data types and typical scenarios such as ad hoc queries and statistical reports, which can truly reflect the performance of major databases in the production environment, thus attracting many internationally renowned databases like Snowflake, Redshift, Athena, Greenplum, Druid ,etc..
The measured indicators include the time taken to import the same dataset, the amount of storage space occupied, and the time taken to execute SQL under a specific machine, which are used to measure data import performance, data compression ratio, and query performance respectively. The one with the best performance in all test results will become the baseline. The indicators of the same test items will be compared with the baseline data and a ratio will be obtained. This ratio will reflect the gap with the best performance. When a new test result exceeds the original baseline, it will automatically become a new baseline.
As far as query performance, hot run and cold run will be executed for each SQL respectively to count the duration, that is, repeat the SQL for three times and select the one with the shortest duration, and execute directly after starting and cleaning the memory. Finally, the ratio of the execution time of all SQL to the baseline will be geometric averaged, which is the final test result. Therefore, ClickBench pays more attention to the excellent performance of the database in all test scenarios, rather than one or several scenarios, which makes the database require all-round capability improvement.
ABOUT SELECTDB
SelectDB is developed based on the commercial requirements of the open-source product Apache Doris. Without the support of Apache Doris community, our R&D speed would not be so fast. Therefore, we would like to thank all the technical partners of the Apache Doris community. All the performance optimization points for SelectDB will be returned to the Apache Doris community without any reservation. At present, some codes have been merged into the community master branch, and many PRs are in the process of merging. We believe that in the near future, all community users will be able to have the ultimate experience brought by the performance leap.
As a new generation of cloud-native data warehouse built from Apache Doris and running on multi-cloud, SelectDB has the core features of extremely fast, single unified, easy-to-use, and cost effective. It provides multi-cloud consistent experience and supports for most data types. Up to now, SelectDB has carried out in-depth cooperation with Alibaba Cloud, Tencent Cloud, AWS, and other well-known cloud service providers, and has serviced many enterprises in different industries.
THE RECORD OF SELECTDB
In the test results, SelectDB reached the top 1 with its strong query performance. Without any tuning, the query performance of SelectDB was No.1 on c6a.4xlarge VM in AWS with 500 GB gp2, and the performance of Hot Run and Cold Run were 35% and 25% ahead of the second respectively. In all 43 SQL statements, SelectDB got the best performance in nearly half of the query statements and become the new baselines. At the same time, the data loading efficiency of SelectDB ranked second among all products in the same machine. Before compression, 70G data writing only took 482s, and the single node writing speed exceeds 140MB/s. This ensures writing efficiency while achieving extreme query performance.
As far as query time consumption, compared with other top products, the overall query time consumption of SelectDB had decreased by 63%, 75%, 78%, 99%, and 459% respectively, and its performance is significantly ahead of similar products.
In the general list of a number of different machines and systems (including the world- famous cloud data warehouses such as Snowflake, Redshift, etc.), SelectDB still had the best Cold Run query performance and the second Hot Run query performance among all products of the same type, demonstrating a strong performance advantage.
In the test results running on the machine of c6a.metal, 500gb gp2 which was another common type, the overall query time of SelectDB in the Cold Run scenario was only 1/4 to 1/10 of that of similar products. Without any tuning, the highest query performance was nearly 11 times higher than that of similar products, showing a hugely leading edge.
SUMMARY
Today’s achievement is one of the goals for SelectDB. In November, SelectDB Cloud will launch the 2.0 version. At that time, more wonderful technologies will be shared with users. Now, users are welcome to apply for a free trial on website (http://en.selectdb.com), the experts will provide professional service for users.
Hashtag: #SelectDB
Services
STAKEHOLDER ENGAGEMENT
Stakeholder mapping, analysis, engagement and communication needs to be detailed to avoid business losses or even worse, a crisis. How can you do this effectively to prevent failure? ...
BUSINESS INTELLIGENCE
Data-driven business decisions have never been as crucial, especially in this era. MGBF leverages off, technology, experience and market presence to aid businesses in making accurate decisions. ...
GOVERNMENT RELATIONS
MGBF provides comprehensive strategic advice and results-focused solutions to solve clients' problems in business-government relations so they can focus on their core business. ...
BUSINESS & BROADER MARKET ACCESS
A critical business challenge is meeting the right decision-makers and potential buyers through the best channel and platform. How will you improve your business competency? ...
Upcoming Events
A WORKING LUNCH WITH NORDIN: BRANDS, BUSINESSES AND BOYCOTTS
Boycotts are not new. Boycotts are not pretty. Boycotts are about creating fear. The question for business leaders is how to deal with this specific type of crisis before, during, and after a brand or a company has been targeted.
A WORKING LUNCH WITH NORDIN: MALAYSIA’S NEW PLACE IN A RAPIDLY CHANGING WORLD
In the year since the change of government, hundreds of billions in bilateral investments have been announced. Beyond the media headlines, what are the opportunities for businesses to grow in Malaysia in 2024?
NETWORKING: LEADING UP TO THE “ASEAN’S FOOD SECURITY NEXUS 2023”
A series of networking sessions with various business associations and trade organisations exploring high-value opportunities for business leaders and entrepreneurs looking to build the relationships that matter.
ASEAN’S FOOD SECURITY NEXUS 2023
This integrated event will include a forum, dedicated business matching, site visits, a gala dinner and a round of golf. Aptly themed, the focus will be on regional food security issues and trends in the context of the supply chain, agriculture technology and trade regulations and policies.
MGBF In The News
Last week SPM results came out, 373,974 aspirants who have been waiting patiently over the last few months would now know their fate. Some 10,109 have received all A’s, the golden standard of academic success and the ticket to those looking to study the “more advanced” subjects in university. Proudly, […]
The classic knee-jerk reaction is to say, fire the coach, change the leadership of associations, and reduce the funding till they start performing better. This kind of negative reinforcement may work for kindergarten children, but we are dealing with high-performance adults – individuals much further along in their psychological and […]
Since its earliest tea plantations in 1929, Cameron Highlands has grown to become a key player in the agricultural landscape of Malaysia, producing 40 per cent of all vegetables grown. Despite Malaysia shifting its economic focus away from agriculture, the industry remains imperative for food security and the livelihoods of […]
Although at first glance the travel industry and the agricultural sector appear to have nothing in common, they actually share more than meets the eye. The economic benefits of tourism to the agricultural sector can be multiplied several times over. “Tourism brings the end consumers closer to the source, which […]
The Malaysia Global Business Forum (MGBF) recently held a high-level roundtable themed ‘Designing the Future of the Digital Economy’, attended by industry leaders and business associations. The guest of honour was Yang Berhormat Syerleena Abdul Rashid, the Member of Parliament (MP) for Bukit Bendera in Penang. The MP’s Special Session […]
The Malaysia Global Business Forum (MGBF) will be hosting a roundtable on ‘Designing the Future of the Digital Economy’ on 23 February 2023. It is the culmination of the first three MGBF Exclusive Roundtable Series titled ‘The Evolving Threat Matrix in the Digital Economy’ held throughout 2022. According to the […]
The Founding Chairman of the Malaysia Global Business Forum (MGBF), Nordin Abdullah, today spoke on Bernama TV’s leading English talk show, The Brief, hosted by Jessy Chahal, on the topic of a stable political reality and what that means for the Malaysian economy. Nordin said, “The first thing that it […]
More than 1,100 years ago, Muhammad ibn Musa al-Khwarizmi was developing the mathematical formulas that we know today as algorithms which now have become so intertwined with the business fortunes of global media giants and the very fabric of geopolitics. A series of recent high level international reports have revealed […]
KSK Land has been recognised by the Malaysia Global Business Forum (MGBF) for its role in attracting high net-worth individuals to Malaysia post-pandemic. The first challenge in investor attraction is “selling” the country. In the context of Asia, Malaysia is competing with some very established investment destinations. The second […]
Malaysia, in particular Kuala Lumpur, continues to position itself as a regional centre to do business, educate a family and enjoy a global lifestyle. One company, KSK Land, has taken the lead in positioning itself and the city of Kuala Lumpur as a property investment destination for the global citizen […]
The upcoming budget represents an opportunity to build resilience in the critical sectors that will form the backbone of the country’s future-facing economic ambitions. This however needs to be achieved in the context of managing the community sectors most impacted by COVID-19 over the past two years. The Keluarga Malaysia (Malaysian Family) […]
KUALA LUMPUR, 6 July 2022 – As the global economy continues to deal with unprecedented levels of disruption caused by the pandemic and the conflict between Russia and Ukraine, the convergence of energy security and food security issues has become a front-of-mind issue faced by policy makers and consumers alike. […]
KUALA LUMPUR, 23 June 2022 — Malaysia Global Business Forum (MGBF) ties up with scoutAsia to ensure that businesses are equipped with deeper regional insights. The past two years has seen a massive shift in the way businesses are conducted with digitisation, digitalisation and automation continuously being adopted to improve […]
KUALA LUMPUR, 25 May 2022 – The Malaysia Global Business Forum (MGBF)’s exclusive roundtable on ‘Security Concerns in Critical Value Chains’ was held in a hybrid setting yesterday at the Eastin Hotel Kuala Lumpur. The guest of honour was Yang Berbahagia Tan Sri Dato’ Seri Rafidah Aziz, former minister of […]
The Malaysia Global Business Forum (MGBF) has released a report following the roundtable on ‘Digital Resilience in the Corporate Sector’, which was recently held in Kuala Lumpur. In attendance as guest of honour was Deputy Minister of Communications and Multimedia, Datuk Zahidi Zainul Abidin. The report recommended several critical development […]
