Announcement Announcement Module
Collapse
No announcement yet.
Which is the best approach to implement to read the data from DB Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Which is the best approach to implement to read the data from DB

    Hi,

    I am using JDBC spring batch to retrieve the data from the DB and delegate these records to the Flat file. For this I have seen two approaches JdbcCursorItemReader and JdbcPagingItemReader. The query which I have to write will written lakhs of records.

    Which is the best way wrt to performance and time..


    Thanks in Advance,
    Siv

  • #2
    if you have a simple cursor which returns lots of data it might be better to go with paging, it depends a lot on the database/hardware

    if the cursor is a big one (read: several pages of sql code) it might be better to build it once and go without paging


    i would test it :-)

    Comment

    Working...
    X