out of memory

[Roberto]

Hi,
when my query extracts more than 200000 records appears a message of error: "Out of memory". what it depends? I set the buffer, in the preference menu, on the max value...what i do ?

p.s.: scuse for my student's english

 

[Marco Kalter]

The SQL Window will load the records into memory, so for 200,000 records you can indeed get such an error, depending on the amount of memory available and the record size.

Why exactly do you query 200,000 records? This should be avoided if possible.

------------------
Marco Kalter
Allround Automations

 

[Roberto]

Originally posted by mkalter:
The SQL Window will load the records into memory, so for 200,000 records you can indeed get such an error, depending on the amount of memory available and the record size.

Why exactly do you query 200,000 records? This should be avoided if possible.

unfortunately the number of the extracted records is right indeed they would have to be in all 618155, and I cannot avoid it. there is a solution?

 

[Marco Kalter]

If you want to export the records, use the "Export Query Results" button of the SQL Window. In that case the data will be exported straight to a CSV, TSV, XML or HTML file, without any memory overhead.

I hope you don't want to see 618155 records on-screen...

------------------
Marco Kalter
Allround Automations

 

[Roberto]

Originally posted by mkalter:
If you want to export the records, use the "Export Query Results" button of the SQL Window. In that case the data will be exported straight to a CSV, TSV, XML or HTML file, without any memory overhead.

I hope you don't want to see 618155 records on-screen...

thanks, this command me will be much profit