From this video, you are working on a relational database with many selections from other tables which can have high latency because it takes time to loop and assign the "items" column to the orders table. Why not use a "left join" to improve this method? If you use the "left join" method, how can you create a relational table with the returned object or array? Thanks for your time.
You are right, JOINs would be better in terms of performance. I chose separate queries to demonstrate database transaction and I don't have any example for the join approach at the moment but i will share once I try them. Let me know if you happen to come up with any solution :)
This series has been awesome so far
glad to hear! comments like this keep me going 🙂
Wow amazing content.. Testing and Database Tx very very important for me.. Keep up Man Keep update your amazing content
Glad to hear that is relevant to you 👍
Great, enjoying the series 🖤. I hope you'll also cover clean architecture in this series.
yup i can do that once i have some pieces together 👍
great content
awesome content
thank you! glad to hear you liked it 👍
Great
so so thank u, please share some video about decorations with sqlx
From this video, you are working on a relational database with many selections from other tables which can have high latency because it takes time to loop and assign the "items" column to the orders table. Why not use a "left join" to improve this method?
If you use the "left join" method, how can you create a relational table with the returned object or array?
Thanks for your time.
You are right, JOINs would be better in terms of performance. I chose separate queries to demonstrate database transaction and I don't have any example for the join approach at the moment but i will share once I try them. Let me know if you happen to come up with any solution :)
great great work. and please finish this project if you wish
thanks! will do 👍