Hi,
I am trying to insert multiple records in a number of few 100 thousands.
This is crashing python. Can i implement parallel processing. I have
read about it , but don't know how to implement.
cursor.execute(("insert into tbl_query_detail(hash_value,file_name,package_name,QUERY_NUMBER,\
author_name,FULL_QUERY,BASE_QUERY_INDICATOR) values \
(A.NEXTVAL,:file_name,
ackage_name,:QUERY_NUMBER,:author_name,:FULL_QUERY,:BASE_QUERY_INDICATOR )"),(filename,Result_list[0],Result_list[ResultListIndex],'abc',Result_list[ResultListIndex + 1], Result_list[ResultListIndex +2]))
My code is actually extracting queries from the code and inserting into
database . That makes almost 1,00,000 queries to be
inserted into database.
THis is a one time activity. SO i am not bothered about performance. But more worried about to see that thepython doesnt get hung in between and insert into db.
I have been using DCOracle2 on unix where it was working fine. I
have shifted to windows and using cx_Oracle as the DB-API.
Which is the best strategy to be followed please suggest.
I am trying to insert multiple records in a number of few 100 thousands.
This is crashing python. Can i implement parallel processing. I have
read about it , but don't know how to implement.
cursor.execute(("insert into tbl_query_detail(hash_value,file_name,package_name,QUERY_NUMBER,\
author_name,FULL_QUERY,BASE_QUERY_INDICATOR) values \
(A.NEXTVAL,:file_name,
ackage_name,:QUERY_NUMBER,:author_name,:FULL_QUERY,:BASE_QUERY_INDICATOR )"),(filename,Result_list[0],Result_list[ResultListIndex],'abc',Result_list[ResultListIndex + 1], Result_list[ResultListIndex +2]))My code is actually extracting queries from the code and inserting into
database . That makes almost 1,00,000 queries to be
inserted into database.
THis is a one time activity. SO i am not bothered about performance. But more worried about to see that thepython doesnt get hung in between and insert into db.
I have been using DCOracle2 on unix where it was working fine. I
have shifted to windows and using cx_Oracle as the DB-API.
Which is the best strategy to be followed please suggest.