Python Database Query Size
philippe.mottin at skynet.be
Sun Nov 12 11:59:46 CET 2000
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
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...
> 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