Arraysize dependent on run time?

Moritz Liebelt <moritz.liebelt-gM/[email protected]> Tue, 23 Aug 2016 17:43:26 +0200
Newsgroups gmane.comp.python.db.cx-oracle
Message-ID <CAGsDTb2ype5e=tdiEU+Gqkvk1j+3V1qgL5NJfkfMnMzVcPpuEA@mail.gmail.com>
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: moritz.liebelt-gM/[email protected]

------------------------------------------------------------------------------

_______________________________________________
cx-oracle-users mailing list
cx-oracle-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users