Is it feasible to use Mysql with Entity Framework 6 and get good CRUD performance?

Asked

Viewed 246 times

-1

It is feasible to use Mysql with Entity Framework 6 and get good CRUD performance?

c# mysql .net entity-framework performance
  • 8

    Since such a small answer is not worth it: yes, it is.

  • Take a look at [tour]. You can accept an answer if it solved your problem. You can vote on every post on the site as well. Did any help you more? You need something to be improved?

1 answer

2

Define good performance.

If it is an acceptable performance, yes, it is feasible, it is proven by having a huge amount of people who have done this.

If it’s to have as much performance as possible, then it’s not viable. It already starts with the Entity Framework, which is an extra layer of access to the database, which on the one hand facilitates certain operations, on the other hand, performs such operations without knowing exactly the best way to obtain the best performance. We can also say that some of the blame may be Mysql itself. If you want maximum performance, there are better options. Of course some will charge some price, but you asked only about performance.

This is a way of saying that the question is not easily answered except with a huge "depends".

But what is more important is that you can only know about viability by having clear parameters and testing with real situations that you will face. But if generic information is enough for you, understand that any product that exists in the market and has users produces results, at least acceptable.

Maybe it’s not the answer you want, but there are no magical, definitive answers.

I prefer not to use these technologies for a number of circumstances, among them it does not give the performance I would like. Only you can answer if they give the performance you’d like.

  • Gypsy, when I quote "Good performance" I am wanting to compare with Sql Server, because there are customers who have a very large database, and do not want to invest in Database. When it comes to technology, I am using WPF,C#,MVVM, and I have achieved good results. It is worth noting that in some cases I use client-server and in other SOA.

  • The answer remains the same.

  • 1

    @Getulio, if you are seeking performance in a SGBD Free for a large database, I advise you to take a look at Postgresql.

Browser other questions tagged c# mysql .net entity-framework performance

You are not signed in. Login or sign up in order to post.