One Star

[resolved] Tmysqlinput: Where clause

Hi,
I am using tmysqlinput to fetch data froma table (Table 1).The data is huge and so i am getting "GC overhead limit exceeded" error. I want to use a where clause when i pull data (So that only small chunk of data is fetched). How to do this?
I want to apply a where condition on two tables. (i.e Select * from Table 1 where Table 1.a =Table 2.a)
Thanks!
1 ACCEPTED SOLUTION

Accepted Solutions
Seventeen Stars

Re: [resolved] Tmysqlinput: Where clause

hi,
simply add your 'where' clause directly into sql request
regards
laurent
2 REPLIES
Seventeen Stars

Re: [resolved] Tmysqlinput: Where clause

hi,
simply add your 'where' clause directly into sql request
regards
laurent
One Star

Re: [resolved] Tmysqlinput: Where clause

OK. Thanks!