[cx-oracle-users] Arraysize dependent on run time?

[Moritz L. <mor...@go...>]

Hi,

I fetch rows form an Oracle Locator DB with web.py and cx_Oracle! I use the
unreleased version of cx_Oracle! Furthermore I read the sdo_geometry
objects in the sql-statement and build a json based on this.

For a 500m-Tile with 4634 rows I need 0,326 (measured time in the browser=
waiting time (DB + Webserver))
For a 500m-Tile with 5081 rows I need 10,1 second???
You can see an overview
  *500m-Tile_A ( 2311 rows)* *500m-Tile_B (3799 rows)* *400m-Tile (4137
rows)* *500m-Tile_E (4634 rows)* *500m-Tile_C (5081 rows)* *500m-Tile _D
(6241 rows)*
*sdo_geometry (cx_Oracle)* 0,18s 0,26s 0,27s 0,326s 10,1s 13,77s
*Size* 729KB 1,2 MB 1,3 MB 1,4MB 1,6 MB 2 MB

Is there anywhere a Threshold? Because the time is increasing and I do not
understand why.
It does not refer to Browser problems. I think that this is depending on
the webserver.

Does someone knows this issue?

-- 
*Moritz Liebelt, B. Sc.*

Murgstraße 19
76437 Rastatt
E-Mail: mor...@go...