Home Original page

Speeding up table generation

Lenny Self lenny at squiggie.com
Thu Mar 9 12:37:08 EST 2000 
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?

I'd really appriciate some help

Lenny Self
lenny at squiggie.com

### Code Below ###

import os
import sys
import MySQL

# Connecting to database server
try:
    dbhandle = MySQL.connect('dbserver,'login','passwd')
    try:
            # selecting database
            dbhandle.selectdb('database')
    except:
            print 'Could not find database'
            sys.exit()
except:
    print 'Could not connect to server'
    sys.exit()

# Querying database for column names
account_columns = dbhandle.do('show columns from table)
# Querying database for body of table
accounts = dbhandle.do('select * from table)

# Creating table
table = '<table><TR>'
a = 0
# Creating column names in table
while a < len(account_columns):
    table = table + '<TD>' + account_columns[a][0] + '</TD>'
    a = a + 1
b = 0
# Creating body of table by going though each record of the query
while b < len(accounts):
    table = table + '</TR><TR>'
    c = 0
    # Going each cell of each record to add to table
    while c < len(accounts[b]):
        table = table + '<TD>' + `accounts[b][c]` + '</TD>'
        c = c + 1
    b = b + 1
table = table + '</TABLE>'
print table
More information about the Python-list mailing list