SAP HANA vs. MySQL - Small test

So...today I wanted to do a little measure between SAP HANA and MySQL execution of Insert statements.

For this, I create a small Python script to prevent myself from copy & paste trauma.

import os
import sys


def Generate_File(pNumber):
    iNumber = 0
    pathname = os.path.dirname(sys.argv[0])
    pathname = os.path.abspath(pathname) + "\HANA_File.txt"
    myfile = open(pathname, "a")
    while iNumber < pNumber:
        iNumber += 1
        myfile.write("insert into HANA_File values (" + str(iNumber) + 
        ",'Test Line');\n")
    myfile.close()
    print 'The file ' + pathname + ' was written successfully'

Generate_File(1000)

When run, this small program will generate 1000 records.

And the table structure for both SAP HANA and MySQL would as simple as:

Id --> Integer
Text --> Varchar(10)

Let's start with MySQL...

MySQL doesn't give us the total amount of time spend, but we can assume about 3 minutes...

Let's move to SAP HANA...

SAP HANA gives us the total amount of time spend, which was 1:18.484 minutes

So we can deduct that SAP HANA was 60% faster than MySQL...and for sure, that's not the best way to load records on SAP HANA...but even like this, you can see how fast SAP HANA really is...

Greetings,

Blag.