Re: Comparing performance with Exadata

Won't be able to comment on the testing strategy however, just for information , I think snowflake was initially built and marketed for OLAP workload but was supposed to have the "Unistore tables" to support OLTP types workload too. Not sure where exactly it stands in current time. But yes with regards to Oracle Exadata , it's being built and marketed for OLAP/analytics type workload along with Oracle's support for traditional OLTP workload since its birth.

On Thu, Jun 22, 2023 at 2:30 AM yudhi s <learnerdatabase99_at_gmail.com> wrote:

> Hello All,
> We are mostly using Oracle Exadata(X9 and DB version 19C) and they are all
> on premises currently. These are currently supporting a variety of
> workloads i.e OLTP + ETL type of workload , reporting application
> involving extensive use of plsql procedures and also UI search screens
> exposed directly to customers. So it's kind of supporting hybrid workloads
> now.
>
> Few of the applications(OLAP Type) are moving to the cloud and management
> wanted to evaluate the Snowflake database for those. Wanted to compare its
> performance and suitability, pros/cons against Oracle exadata. But mainly
> wanted to compare the performance of these two.
>
> We know Snowflake does not have indexes, user defined partitioning , but
> relies on micro partitions to filter out data , it doesn't have constraints
> etc. But they have separation of storage and compute i.e both can
> independently scale. It's columnar in nature etc. At the same time, we are
> also hearing of snowflake DB serving many critical OLAP /analytics type
> workloads.
>
> Apology if this is silly one , but colleagues were thinking of just
> dumping/creating billions of rows in a table and then have read/write
> queries run on top of that table, with similar structure in both the
> databases and comparing the response time. But i believe, as each database
> has their strengths/weaknesses so i am wondering if this simple way of
> testing would be really going to give us a fair result about the
> performance comparison. Please guide me here.
>
> Want to understand from experts here , on how we should test and compare
> the performance of the databases in such cases to make any decision? Or
> anybody has experience using these databases as compared to Oracle Exadata?
>
> Regards
> Y
>

--
http://www.freelists.org/webpage/oracle-l