Close Cursor - Best Practise
Anurag Chourasia <[email protected]>
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CANFgmFCHSiKYbHO9nzYQci+P74AWBUcgwgB+C4WGo0T=SZf1tQ@mail.gmail.com> |
I will be executing 4 SQL Queries one after the other. Each query will return a good number of records (> 50000 Records) I am planning to use the same cursor variable for all the queries to fetch the records into. What is the best practise w.r.t closing of the Cursor? Shall i close the cursor after executing and fetching records for each query? Or Shall i use the same cursor without closing and fetch the records and close it only once after having executed all 4 queries? Regards, Guddu ------------------------------------------------------------------------------ Slashdot TV. Video for Nerds. Stuff that matters. http://tv.slashdot.org/ _______________________________________________ cx-oracle-users mailing list cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/cx-oracle-users