Dp agent keeps going down when ever we run a query on Virtual table. How can we resolve this?

Hi Everyone

SDI Dp agent keeps going down when ever we run a query on Virtual table which is pointed to a table with 250 Million records. How can we resolve this?

Adapter used: Camel JDBC Adapter

Source system: MySQL ( No time out limit set at server level)

Thanks and Regards

Srujan