Is there a performance difference between Regular Worksheet, vs. SQL Worksheet?

Answered

Follow

Kang

• October 29, 2019 21:50

Hi,

Just as title asks...does using an SQL Worksheet to get the same data execute faster than running things in a regular worksheet?

I can see a benefit in SQL of embedding data using subqueries, saving a step from having to build separate worksheets.

Thanks

 

1

• Official comment

  

  Konsta Danyliuk

  • October 30, 2019 08:23

  Hello Kang.
  
  SQL Worksheet has been introduced to let people that have SQL background feel more comfortable with the data transformation process in Datameer. Under the hood, SQL queries are being converted into a set of traditional functions at a job's compilation step. You could consider a SQL Worksheet as another interface that allows building the logic in a Workbook. Thereby there is no performance difference between Workbooks that have been built using SQL Worksheets in compare with exactly the same logic represented with the regular functionality.

  Please keep in mind that the logic itself significantly influences job performance and incorrect usage of a formula or unoptimized SQL query increases execution time.

  Comment actions Permalink
• 

  Kang

  • October 30, 2019 17:52

  Thank you

  0

  Comment actions Permalink

Please sign in to leave a comment.