Few, complex OR many, simple MySQL queries? - Hack The Tech - Latest News related to Computer and Technology

Hack The Tech - Latest News related to Computer and Technology

Get Daily Latest News related to Computer and Technology and hack the world.

Thursday, March 24, 2022

Few, complex OR many, simple MySQL queries?

Im working on a onlineshop with php.

I work with the mvc model and I divide each small part of my application in: model view controller and service ( service is there for the query ).

So for example I would have a Item cart which is divided in discription and price...

For each of them I would have a seperate query, for example the discription: 'SELECT discription OF ... WHERE ...'

So my questin is:

Is there any downside ( like a worse performance ) if I use many simple MySQL queries instead of one complex query?



source https://stackoverflow.com/questions/71585407/few-complex-or-many-simple-mysql-queries

No comments:

Post a Comment