mysql performance with Dataservices 4.2

[Former Member]

I'm testing Dataservices 4.2 with mysql 5.5.

Copy 58 000 rows  from Mysql to  another Mysql Database on the same instance 43 s

Copy 58 000 rows from mysql  to MS sqlserver 2008   3s

Copy From Oracle, MS sqlserver 2008, ...  to mysql     40 s

Copy From Oracle, MS sqlserver 2008, ...   to MS sqlserver 2008     10 S

I check also a copy  with mysql workbench  6.2 wizard from another database to mysql and the results is 10 s

Can somebody help me. is it a problem of Mysql system or a problem Dataservices- Mysql ??

Ps: i have the same problem with mysql 5.1

[former_member211387]

Hi

The list of possible issues is endless in such cases.

First check your hardware. Is the MYSQL installed on the same disk as the data services ? Then, if the disk is not a high rpm variety with a substantial amount of cache, then you will face such a situation.

Does the MYSQL database server have the same kind of hardware configuration like the MSSQL databse server you are benchmarking against.

Start your checks with these and if we can eliminate these obvious areas where performance can be an issue, then we can focus on other issues.

kind regards

Raghu