Guys I am go through an issue that if i have a table containing 3 column & 500 rows(It contains the TInt32id,). I have to search for the existence of these 500 ids in these rows & 1st column. If it exist than it will return the value true.
If i am putting the linear search then loop will go for 500*n times & it will take to much time.
I was looking in the class of RDbTable & RDbRowSet. But didn't find any inbuilt API to compare these value.
Please guide me for the same. Do we have any in built API. Or i should apply the concept of Normal Data structure.