Performance Problems when selecting HUGE amounts of data from MySQL dbs

Steve Holden sholden at holdenweb.com
Wed Jan 9 17:28:06 CET 2002


"Skip Montanaro" <skip at pobox.com> wrote in message
news:mailman.1010591172.21624.python-list at python.org...
>
>     Gabriel> db.execute("SELECT myfield FROM table")
>     Gabriel> data=db.fetchall()
>     Gabriel> giantstring=""
>     Gabriel> for record in data:
>     Gabriel>     giantstring+=record
>
>     Gabriel> but this is way too slow.
>
> How about
>
>     db.execute("SELECT myfield FROM table")
>     data=db.fetchall()
>     giantstring=[]
>     for record in data:
>         giantstring.append(record)
>     giantstring = "".join(giantstring)
>
or
    db.execute("SELECT myfield FROM table")
    giantstring = "".join([itm[0] for itm in db.fetchall()])

regards
 Steve
--
http://www.holdenweb.com/








More information about the Python-list mailing list