Agile PLM Export Bulk data using SDK

Hi Everyone,

I want to export all items data from agile using SDK. I have 3.92 lakhs records.

I am using below code :-

AgileUtility.iAgileSession = initialize agile using proper username and password

query = (IQuery)AgileUtility.iAgileSession.createObject(IQuery.OBJECT_TYPE,

.CLASS_ITEM_BASE_CLASS);

itemsQuery,itemsubClass = "";

try {

query.setCaseSensitive(false);

ITable results = query.execute();

Iterator itemit = results.iterator();

Iterator ite=null;

while

(itemit

.hasNext()) {

itemsQuery = "";

IRow affectedItemRow = (IRow) itemit.next();

String ItemNUmber = affectedItemRow.getValue(ItemConstants.ATT_TITLE_BLOCK_NUMBER).toString();

String ITEMLIFE = affectedItemRow.getValue(ItemConstants.ATT_TITLE_BLOCK_LIFECYCLE_PHASE).toString();

itemsubClass = affectedItemRow.getValue(ItemConstants.ATT_TITLE_BLOCK_PART_TYPE).toString();