Skip to Content
0
Former Member
Jul 28, 2015 at 01:52 AM

ASE1570 VS ASE1254

81 Views

I have a simple test about insert speed between ASE1570 and ASE1254.

Any idea to improve the throughput about ASE1570.

Testing Env:

ASE1570 SP130

ASE1254 ESD11.2

running on the same box.

Here's the testing steps:

use tempdb

go

create table MM (

MM01 int not null ,

MM02 numeric(8,0) identity ,

MM03 char(1) not null ,

MM04 char(8) null ,

MM05 datetime not null ,

MM06 char(7) not null ,

MM07 char(5) not null ,

MM08 char(1) not null ,

MM09 char(7) not null ,

MM10 char(7) not null ,

MM11 char(1) not null ,

MM12 char(20) not null ,

MM13 char(10) null ,

MM14 char(10) null ,

MM15 char(1) not null ,

MM16 char(1) null ,

MM17 char(1) null ,

MM18 char(1) not null ,

MM19 char(4) not null ,

MM20 char(1) null ,

MM21 char(3) null ,

MM22 char(1) null ,

MM23 smallmoney not null ,

MM24 smallmoney null ,

MM25 smallmoney null ,

MM26 smallint not null ,

MM27 smallint null ,

MM28 smallint null ,

MM29 int null ,

MM30 int null ,

MM31 smallint null ,

MM32 char(1) null ,

MM33 char(1) null ,

MM34 char(1) null ,

MM35 char(1) null ,

MM36 char(1) null ,

MM37 char(7) not null ,

MM38 char(1) not null ,

MM39 char(6) not null ,

MM40 char(5) not null ,

MM41 char(1) not null ,

MM42 char(7) not null ,

MM43 char(1) not null ,

MM44 char(6) not null ,

MM45 char(5) not null ,

MM46 char(1) null ,

CONSTRAINT PK_MMTSF PRIMARY KEY NONCLUSTERED ( MM01,MM02 ))

go

edit a sql file for example 1.sql:

use tempdb

go

truncate table MM

go

select getdate() as DT into #TT

go

INSERT INTO MM (MM01,MM03,MM04,MM05,MM06,MM07,MM08,MM09,MM10,MM11,MM12,MM13,MM14,MM15,MM16,MM17,MM18,MM19,MM20,MM21,MM22,MM23,MM24,MM25,MM26,MM27,MM28,MM29,MM30,MM31,MM32,MM33,MM34,MM35,MM36,MM37,MM38,MM39,MM40,MM41,MM42,MM43,MM44,MM45,MM46) VALUES

(1,'I','549 ','2015-01-01 10:08:17.306','A100000','ZZ001','O','A100000','0000333','1','TTO0100000 ',' ',' ','S',' ',' ','0','F905','S','000','L',100.0000,0.0000,0.0000,10,0,0,10,0,0,'O','O',' ','I',' ','TXO ','C','201508','09000',' ',' ',' ',' ',' ','1')

go 5000

select datediff(ms,DT,getdate()) from #TT

go

and using isql to exec the 1.sql:

the result will look like:

ASE1570

/home/sybase/ase/phsu > isql -Usa -SSYBASE -Psybase -i1.sql

(1 row affected)

(1 row affected)

5000 xacts:

-----------

6176

ASE1254

/home/sybase/ase/phsu > isql -Usa -SASE1254 -P -i1.sql

(1 row affected)

(1 row affected)

5000 xacts:

-----------

3476

We can see ASE1254 is faster then ASE1570, any idea to improve ASE1570 throughput?