This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Yes, I have a specific requirement, I need all the data, iterate through the values and based on some particular logic, needs to identify certain values that satisfies certain conditions and use it in the next query thats fired.
If you have some idea of achieving this, request you to let me know.
By default, it gets me only certain set of records and once I finish iteration on this set, it fetched the next set of data.
Thanks & Regards Narasimha
author & internet detective
Narasimha, If you can employ any more filtering in the where clause, do that. But it sounds like you already tried.
Another thing to suggest is to do your logic check in a stored procedure. That way all the data doesn't need to be transmitted. If you don't have control over the remote database or the network, there isn't much you can do.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com