Level 13
Are the columns you are constraining the query to, indexed? name and purchase_price ?
1 like
Sep 26, 2021
9
Level 7
Is there is a better way to perform this query
select name, purchase_price from products where name='alisda' and purchase_price=1
query in MySQL is being executed too long, the table has 50m rows. What’s the best way to analyze and resolve the issue.
Level 7
@Tippin Yes they are.
Level 18
@umairparacha Check if you have the indexes in the same order than the conditions. That will help
Level 7
@narcisonunez21 I just want to ask if there is some better way to write this query.
Level 75
Bind your parameters.
1 like
Level 7
@jlrdw I am not quite familiar with binding parameters. Can you please explain how to bind parameters? Thanks
Level 75
@umairparacha https://laravel.com/docs/8.x/database#running-a-select-query
Scroll down a little.
1 like
Level 7
@jlrdw Thanks for helping out. what are the advantages of using parameters binding?
Level 54
@umairparacha allows you to sanitise inputs which prevents SQL injection vulnerability
1 like
Please or to participate in this conversation.