malvika garg Posted September 19, 2019 Share Posted September 19, 2019 I'm trying to fetch data fom sql server data source using simple IL without any filters but its taking 1 hour to fetch 130000 rows. In sql srver this view is taking only 10 mins to load the data. can anyone pls suggest me some solution on this. Link to comment Share on other sites More sharing options...
Harshith Reddy Musku Posted September 19, 2019 Share Posted September 19, 2019 I would suggest you to compare the results from a JDBC tool (eg. Dbvisualizer) instead of management studio. Follow the below article and see if that helps https://support.tibco.com/s/article/Troubleshooting-Guide-Performance-issues-with-Information-Links Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now