How to speed up data extraction from Mysql database

Question

I am working with a C # form application and use mysql as the end. I have a table employee. In that I have more than 2000 lines, this is just an example, most likely more records. When I retrieve and filter data from the database, my application becomes slow. Is there any other way to get the database at a good speed? Should I achieve speed with Linq?

Answer 1

Just make sure that you are filtering the database using WHERE (if you are using SQL to access the data).

If you use linq or not, it doesn't really matter if the SQL that is running in the database is good (proper filtering using WHERE and indexes).

Answer 2

How do you get the data now? are you using ado.net? but stored procedures with ado.net is the fastest way, I think you are sure that data extraction is the slowest, 2000 records are not such a big table, so I suppose your user interface components are slower?

Answer 3

2000 - . ?

/ DB.

• .

• , , / .

If you publish your request and its execution plan, people may indicate some features regarding how you can improve it!

Answer 4

You can speed things up by using lazy loading (there are several tutorials over the Internet) or just pick the ones that interest you.

Answer 5

add an index to your fields participating in JOINSand WHERE.