On Apr 12, 2012, at 4:19 PM, John Fabiani wrote:

>               for tb in tbls:
>                       fldDict = {}
>                       flds = crs.getFields(tb)
>                       for fld in flds:
>                               fldname = fld[0]
>                               fldInfo = fldDict[fldname] = {}
>                               fldInfo["type"] = fld[1]
>                               fldInfo["pk"] = fld[2]
>                       self._dataEnv[tb] = fldDict
>               return True

        Looking at this, I'm wondering if it could be sped up a bit using a 
list comp:

self._dataEnv = dict([(tb, dict([(fld[0], {"type": fld[1], "pk": fld[2]})
        for fld in crs.getFields(tb)])) 
        for tb in crs.getTables()]) 

        I don't have any db schemas that would generate a noticeable time 
difference. Cheryl, if I sent you a modified version of the wizard, would you 
be able to test it out to see if it improves the performance for your database?


-- Ed Leafe



_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: 
http://leafe.com/archives/byMID/1afa15c4-8270-4e45-be4c-b0b21ccd4...@leafe.com

Reply via email to