Daniel Demesmaecker wrote:
Amin Saberi wrote:
My question is what is the best practice to design these kind of custom APIs? I need to implement it as efficient & fast as possible
lol... My guess is that efficient & fast and this design shouldn't be in the same sentence, it makes no sence to me why you would want to create something like this.
It will give you tons of records you don't need. Let's say you want everyone who's firstname is george and you search for like %george% in all your columns.
In you're db you have 10.000 people who live in Georgetown. Do you really wan't your db to return thoose values?