MSSQL vs MySQL Datasource
Are there any performance, feature, or stability advantages of one over the other?
I ask as I have about a thousand entries and using RDM from my flash drive remotely tends to run horribly and have authentication issues so I was contemplating testing out MySQL. Server bandwidth is not the issue.
All Comments (5)
Hi,
What data source type do you use on your flash drive? SQL Server and mySQL should have approximately the same performance but to be honest we do more performance testing and improvement on the SQL Server data source.
David Hervieux
Microsoft SQL Server 2008 R2 Express
Hi,
Do yo have multiple users connected to the SQL Server?
David Hervieux
Could you try the beta version tomorrow (9.0.14.0)? We have made multiple optimization and perhaps one of them was good for your scenario.
David Hervieux
Mostly a single user, at most 4 users. I will give that a shot, thank you.