0

Basically, I have created an Excel addon which connects to Odoo ERP server using xmlrpc and gets an array object. Everything is working well except when number of records are huge, it fails and throws memory error.

Could someone suggest a better practice to achieve this functionality where the data volume is huge. Below code I am trying on server side in Python.

sql = " SELECT * FROM table" 
cr.execute(sql) # 1 Million records, Executes fine
data = cr.fetchall() #Fails and gives memory error
return data

Thanks, Burhan

Anis Ghee
  • 121
  • 2
  • 4

1 Answers1

0

Try something like this: https://docs.python.org/3/reference/datamodel.html#object.iter

sql = " SELECT * FROM table" 
cr.execute(sql) # 1 Million records, Executes fine
for row in cr:
    doSomething(row)
oshaiken
  • 2,593
  • 1
  • 15
  • 25