This content has been marked as final.
Show 2 replies
-
1. Re: Teiid Performance when query large amount of data
rareddy Jun 28, 2013 9:05 AM (in response to neetacomp)what console? if you are caching the results on the client side, then soon you will run out memory! This is not performance issue.
-
2. Re: Teiid Performance when query large amount of data
shawkins Jun 28, 2013 9:17 AM (in response to rareddy)99,999 records unless they are exceeding wide does not seem like a large amount of data. There isn't enough detail to determine where your problem may be. If you can post the query plan for the query that your client is calling, then that would help clarify. For example is your procedure executing a source query in some kind of a nested loop or performing other resource intensive operations.