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