Skip to Content
0
Former Member
Jul 18, 2014 at 02:40 PM

Slow ddlgen in SYBASE 15.7

145 Views

Hi @all,

I'm facing a slow ddlgen in SYBASE 15.7:

Hardware: ORACLE T5-2

OS: Solaris 10

ASE: Adaptive Server Enterprise/15.7/EBF 21336 SMP SP101 /P/Sun_svr4/OS 5.10/ase157sp101/3439/64-bit/

time ddlgen -Usa -SYYYYYY -PXXXXXX -TU -N db_intas01.dbo.server_client_log

...

...

real 0m1.434s

user 0m2.155s

sys 0m0.287s

compared to SYBASE 15.0.2:

Hardware: SUN M5000

OS: Solaris 10

ASE: Adaptive Server Enterprise/15.0.2/EBF 15679 ESD#5/P/Sun_svr4/OS 5.8/ase1502/2528/64-bit

time ddlgen -Usa -SYYYYYY -PXXXXXX -TU -N db_intas01.dbo.server_client_log

...

...

real 0m0.684s

user 0m0.384s

sys 0m0.155s

On average T5-2 seems to be 15-20% faster as M5000 but for ddlgen.

Any help would be appreciated!

Regards,

Heinz