Arraysize dependent on run time?
Moritz Liebelt <moritz.liebelt-gM/[email protected]> Tue, 23 Aug 2016 17:39:55 +0200
| Newsgroups | gmane.comp.python.db.cx-oracle |
|---|---|
| Message-ID | <CAGsDTb0cc3RFxwURJjNeBbWfNup4f_PP-cg47XFEA4hF96zysw@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 in the attachment. 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
overview.JPG
(image/jpeg, 33 KB) - not displayed