Speeding up table generation
Aahz Maruch
aahz at netcom.com
Thu Mar 9 14:33:54 EST 2000
In article <yjRx4.55$gi1.3993 at news.uswest.net>,
Lenny Self <lenny at squiggie.com> wrote:
>
>Hello. I am rather new to Python and programming in general. I have
>created th following function in order to display the contents of a query
>from a MySQL database in an HTML form. With the number of records I am
>working with the table building portion of this function takes quite some
>time ( 7 - 10 seconds). 7 to 10 seconds isn't all that bad but it's
>possible the database will grow quite a bit and displaying all of the
>records could take quite a while. Does anyone have any suggestion for me
>that might help speed this function up?
Side note: even if you speed up table creation, your users will get
pissed at tables that have more than about 100 records. It takes a
*long* time to generate the screen. You might want to find some way of
nicely formatting the data without tables; another option is to make
each row its own table (forcing you to specify the width in %).
--
--- Aahz (Copyright 2000 by aahz at netcom.com)
Androgynous poly kinky vanilla queer het <*> http://www.rahul.net/aahz/
Hugs and backrubs -- I break Rule 6
"Along the lines of getting a massage, taking a hot bubble bath, and
swimming in a pool of warm, melted chocolate, can you give me some
innovative ways that you pamper yourself?"
"Spend three hours flaming stupid people on the Net." --Aahz
More information about the Python-list
mailing list