Python Database Query Size

Philippe mottin philippe.mottin at skynet.be
Sun Nov 12 11:59:46 CET 2000


Hi,

Recently, i've used ODBC API from PYTHONWIN to access an ORACLE database.
I was able to read 80000  rows from a table without problems using
fetchall().

I think the limit  of  fetchall() is the limit of  the memory and not a
limit  of  the LIST.

<ryzam at my-deja.com> a écrit dans le message : 8ul6fj$4uj$1 at nnrp1.deja.com...
> Hi,
>
> I have arround 1000000 rows of data in my oracle database. I'm using
> python ODBC-API to make a connection and query the database. Just want
> to know how large python fetchall() and fetchmany() can query the
> databse.This is because when i'm trying to query about 10000 row of
> data from my oracle database, my idle was stop working.
>
> This is also happen in Zope Webserver.Right now i'm running zope as a
> standalone web server on windows platform. When i'm trying to query an
> heavy database Zope web server cannot had had thread service that means
> another user cannot acces to zope.. the system also 'hang-up'.
>
> I'm trying to check to another programme like php and asp to see it
> performance. I think python list '[]' size cannot hold large data in
> one time.. it will crash...
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.





More information about the Python-list mailing list