I am using where clause for searching some Field 'Client ID' but when i am loading the data all the qvds one by one Date wise start loading and search for that particular Client ID as we are having thousands of qvds it is not possible to load all. so what way i can load only that particular dates qvds in which that clientID Exists without loading all as i don't know the date when that client ID was created in the system.
Trying to follow along, you're trying to only load QVDs (which are each for specific date ranges) which might have a certain Client ID, and the way to know this by checking which date ranges that Client ID has appeared in? That seems like circular logic - you won't know which QVDs to read until you read the QVDs. Perhaps I misunderstood the description?
