on 01-14-2015 9:19 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.