Skip to Content
0
Former Member
Dec 09, 2012 at 11:17 AM

Sybase IQ and HANA. Insert as select speed.

29 Views

Dear community.

My results for mass inserts.

Environment

Sybase IQ (15.4 ESD2) - 8CPU Xeon (2009), Hi-End array.

HANA Box (SPS5, Rev 45) - 40CPU E7 (2011), midrange array.

TABLE TST - (87 columns), 145 mln rows. Primary key - 6 columns.

Results:

IQ - 43 mins

HANA - 50 mins.

Attachments

09.12_IQ2.jpg (38.1 kB)
09.12_IQ2.jpg (38.1 kB)
09.12_IQ2.jpg (38.1 kB)