Hi,
I have created a webserver with python and cx_Oracle.
But now I have a problem to fetch the data. Sometimes my tiles have more than 5000 output rows. So in the cx_Oracle interface it is written that the default value for arraysize is 50. If I increase the value of 10.000 (cursor.arraysize = 10000) it works fine. But a value lower than 5000 needs milliseconds and a value bigger than 5000 needs some seconds. You can see the results in the picture
!
Furthermore it is written in the Oracle Docu:
_SET ARRAY[SIZE] {15 | n}
Sets the number of rows, called a batch, that SQL*Plus will fetch from the database at one time.Valid values are 1 to 5000. A large value increases the efficiency of queries and subqueries that fetch many rows, but requires more memory._
Does anyone have experience with sql queries more than 5000 output rows by using webframeworks (web.py, ...)???
So I think the results are regarding to this that over 5000 is not a valid value so the execution time is increased strongly...Is this right?
Is there a way to avoid this ?