Hello team,
I have 14 lakh data entries from a database that I want to retrieve and store in a runtime datatable. I’ve tried using the query “select * from tablename,” but it’s taking too much time, sometimes causing the system to hang. Are there any alternative methods to fetch data from the database more efficiently?
Might be good idea to filter with what you really needed instead, for example SELECT * FROM tablename WHERE ***
Otherwise use limit plus filters to get and process in batches SELECT * FROM tablename WHERE *** LIMIT 50000
i was already done it but after 10 iteration it wil take more time(bot stuck). i want to store all data in runtime datatable