report output taking to much time in virtual datasource

[ghanshyam.gupta]

Hi ,

 i am using virtual data source in jasper , so created a virtual datasource and add two datasource

1 .Datasource1 using MSSQL Database

2. Datasource2 using MySQL Database

now everything working fine except this is taking too much time - more then 6 minute to output data in the report even output is just 10 rows .

i am not getting how virtual db internally treating/converting my query .

please help .

 

thanks,

ghanshyam