Get the latest Laravel/PHP jobs, events and curated articles straight to your inbox, once a week
Source: blog.cognitiven.tech
Why indexing your database can benefit your REST API?Category: MySQL, MySQL
For this presentation I am using: I have created a small repo, that you can check the REST API logic and so that the benchmarking is more reliable.
So as you can see from the SQL files in the repo my table is pretty simple it consists of 3 fields and the most interesting is the json field which is of JSON type and looks like this.
The “problem” about this index type is that you have to query for the leftmost value to use the index.
The main case I can think of right now is the one that you create a temporary table in the memory with a set of results from another select and perform a lot of other selects in this temporary table using hash indexes.
Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox.Explore
So as you can see from the SQL files in the repo my table is pretty simple it consists of 3 fields and the most interesting is the json field which is of JSON type and looks like this.
The “problem” about this index type is that you have to query for the leftmost value to use the index.
The main case I can think of right now is the one that you create a temporary table in the memory with a set of results from another select and perform a lot of other selects in this temporary table using hash indexes.
Follow the writers, publications, and topics that matter to you, and you’ll see them on your homepage and in your inbox.Explore
Newsletter
Glimpse
Glimpse streamlines Laravel development by seamlessly deploying GitHub pull requests to preview environments with the help of Laravel Forge.
Community Partners
Laravel/PHP Careers