lundi 30 novembre 2015

rest api optional query parameters and sql indexes

I see a lot of rest api's that have at least 5-10 optional query parameters that filter result sets. Easy to use from a client perspective but how are people creating sql indexes for all the query combinations?

For keyword usage I know full text is an option but I am talking about exact filters or ranges etc.

Aucun commentaire:

Enregistrer un commentaire