Which is better for performance ?

I make use of both. In terms of speed of execution, it depends on how complex ur database is.

emetisuccess:
I make use of both. In terms of speed of execution, it depends on how complex ur database is.

It’s an e-commerce tech store for a small business. I will try eloquent .

Both are good depending on the programmer I use both but for more complex queries I use query builders for cases like (sub queries, or joining a sub queries or even doing some calculations directly on the database b4 spitting the result out) but I think when it is time to do things like organising the return data's base on relationship I thing eloquent is really good at it both when I think the power comes best is when you use both together

Using query builder for complex queries and then infusing/converting it to eloquent models for easy organization of relationship and ure next orgasm will be intense gracias

chukwuebuka65:
Which is better for performance ?

Performance in practical sense is not dependent on both of them. It’s about the actual query that eventually hit your db and how optimized is your db against such query. So use telescope to see the actual query that eventually gets to the DB

stanliwise:

Performance in practical sense is not dependent on both of them. It’s about the actual query that eventually hit your db and how optimized is your db against such query. So use telescope to see the actual query that eventually gets to the DB

Ok. Thanks

peterincredible:
Both are good depending on the programmer I use both but for more complex queries I use query builders for cases like (sub queries, or joining a sub queries or even doing some calculations directly on the database b4 spitting the result out) but I think when it is time to do things like organising the return data's base on relationship I thing eloquent is really good at it both when I think the power comes best is when you use both together

Using query builder for complex queries and then infusing/converting it to eloquent models for easy organization of relationship and ure next orgasm will be intense gracias

I didn’t know this was possible. I will research on that. Thanks for the insight.

chukwuebuka65:


It’s an e-commerce tech store for a small business. I will try eloquent .

okay It'll be faster then

chukwuebuka65:


Ok. Thanks

If it’s about searching let’s say for e-commerce. Be sure to start considering elastic search or something of that nature. DB spool for advance search aren’t optimal