Performance MySQL <> MsSQL

[OldManRiver]

Hi

I am in the process of migrating several MySQL databases to Sql Server, but I am experiencing severe performance loss.

When running my application, which have many requests of small amounts of data from large tables, MySQL is several milliseconds faster on each request, Sql server has up to 200 Ms longer response time than MySQL.

Is there something general, that I can do to increase performance for Sql Server ?

I have already made sure that none of my requests fetch more records than needed.

I am running my application under Citrix.

Thanks in advance

Jens Lund

[AndreyZ]

Hello,

MySQL and SQL Server differ a lot, so there will be definitely some performance loss when migrating from MySQL to SQL Server. Please specify the exact situation when you encounter performance loss and we will try to help you.

[CristianP]

MySQL and SQL Server differ a lot, so there will be definitely some performance loss when migrating from MySQL to SQL Server.

We have a customer that migrated from MySQL (MyISAM) to SQL server. I think three years ago.
And they said my application is moving faster with SQL Server.
Maybe because MyISAM in older MySQL implementations are blocking whole table when writing into and performance boost was for heavy server load.

Best Regards,
Cristian Peta

[AndreyZ]

Please try creating a small sample that demonstrates the problem and send it to andreyz*devart*com . After this, I will be able to give you a more valid answer.