We have 1lakh records in table and while using sql select statement , it is taking more than 9mins to 12 mins to get the records. could you please how to optimize this performance issue if we have more records. how to optimize it.
We have 1lakh records in table and while using sql select statement , it is taking more than 9mins to 12 mins to get the records. could you please how to optimize this performance issue if we have more records. how to optimize it.
It would be better if you can add your SQL query, and if it is not a secret also Classes definition. So, we could see if something may be wrong with it. And you also should look at the book in the documentation about SQL Optimizations.
I fear you will have to give us more information before a helpful advice can be given.
And last not least
Kumaresan, I have removed the "Developer Community FAQ" tag which is intended for use on posts about the DC software itself. I have added the "SQL" and "Performance" tags.