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




  • Official comment
    Konsta Danyliuk

    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

    Thank you

    Comment actions Permalink

Please sign in to leave a comment.