Question MySql query

[gate7cy]

I have a question on what is the best way to do something. I am converting our application to MySQL and I am wandering where to create my queries. So far they where created in the VB dataset designer and used from there. What is the best way to do this. Create them directly on the db or in the dataset designer. Does either way affect performance, speed, reliability? Thank you for the replies from beforehand.

cheers

 

[jmcilhinney]

It's really up to you. If you install Connector/NET from MySQL then you can generate a Data Source in the IDE, just as you can for Access and SQL Server. It might even provide Entity Framework support, although I'm not sure of that. You can write your own SQL code in your app if you want to as well, or you can write stored procedures in the database. Note also that writing stored procedures still doesn't preclude you from creating a Data Source, which can use sprocs as the source as well as tables. Each option has its own advantages and disadvantages but they'll all do the job.

 

[gate7cy]

thanks for the reply. on the issues with performance and speed; which one whould you recomend?

cheers

 

[jmcilhinney]

Unless you're talking about a very large amount of data or very complex queries, I doubt you'd see a significant performance difference among the different choices.