on 09-20-2006 1:12 PM
Hi All,
What is the maximum number of records a sender JDBC adapter can process? I need to process very large number of records (may be 100,000). When I select 1000 records, the adapter works fine but when I try with 1500, it does nothing.
Can you share your ideas on this plz...
Thanks & Regards,
Jai Shankar.
Hi Jai,
there's a great possibility that with very large number
of records the flow will finish with errors
can you send many 1000?
this should be faster
and if an error will occure you will
need to correct only one small part
BTW
if you see an error you need to check it
(DB profiler or from jdbc adapter logs)
I don't think there are some constant limits
Regards,
michal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>><i>When you say many 1000's, do you mean by using SELECT UPTO 1000?? Is there a way I can do an update on these 1000's alone??</i>
Answering Antonios question, this should be possible using the Select query in the JDBC adapter. An SQL guru should surely be able to filter records in such a way.
Regards,
Bhavesh
delated content
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
71 | |
26 | |
10 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.