6 Replies Latest reply: Nov 16, 2016 12:22 AM by Ashok Vaddireddy RSS

    Loading records from MySql is not working with limit greaterthan 9000

    Ashok Vaddireddy

      Hi,

       

      I have some tables MySql DB that has more than 7 million records. When I tried to load records (as Select * from Table;) with no limits, it is not even starting the execution (It just says connected to DB and freezes out even after one hour). And if I give limit as 9000 then it works perfectly fine. I am not able to understand where the problem is. And I asked DB team to check the Indexes of table. They said everything is fine on their side.

       

      Could some one please help me with this issue.

       

      Thanks.