On Friday 08 May 2009 06:35:28 am Ed Leafe wrote:
> On May 8, 2009, at 8:19 AM, johnf wrote:
> >> bizobj.cancel() method instead?
> >
> > *** PROFILER RESULTS ***
> > cancel (/home/johnf/downloads/dabo/dabo/biz/dBizobj.py:468)
> > function called 1 times
> >
> > 99 function calls in 0.004 CPU seconds
>
> So that confirms that cancel() is not the issue.
>
> Perhaps you should profile starting with the call to close the form.
>
>
> -- Ed Leafe
I thought providing the SQL (of the table in question) at the time of close
might help to understand what is going on. The where clause is dynamic a
result of a dropdown selection.
select "sessionid",
"courseid",
"essess"."instrid",
"sequenceid",
"essess"."began",
"essess"."ended",
"cancelled",
"essess"."name_1",
"essess"."locationid",
"essess"."facility",
"availseats",
"essess"."depart",
"essess"."pkid",
"stop_close",
"monday",
"tuesday",
"wedesday",
"thursday",
"friday",
"saturday",
"sunday",
"langid",
"start_time",
"end_time",
"essess"."note",
"eligiblecourses",
"topic",
"total_hours",
"total_classes",
trim(esinstr.fname) as instname,
trim(esloc.facility) as location
from "public"."essess"
left outer join "public"."esinstr" on esinstr.pkid=essess.instrid
left outer join "public"."esloc" on esloc.pkid=essess.locationid
where topic = 43
order by "began" DESC
*** PROFILER RESULTS ***
confirmChanges (/home/johnf/downloads/dabo/dabo/ui/uiwx/dForm.py:126)
function called 3 times
4575677 function calls (4575671 primitive calls) in 65.248 CPU
seconds
Ordered by: cumulative time, internal time, call count
List reduced from 247 to 40 due to restriction <40>
ncalls tottime percall cumtime percall filename:lineno(function)
3 0.000 0.000 65.248 21.749 dForm.py:126(confirmChanges)
3 0.000 0.000 65.248 21.749 profile:0(<function
confirmChanges at 0x8f1f87c>)
3/1 0.000 0.000 64.684 64.684 dBizobj.py:461(cancelAll)
3/1 0.000 0.000 64.684 64.684 dBizobj.py:743(scanChangedRows)
1 0.000 0.000 64.684 64.684 dForm.py:416(cancel)
1 0.028 0.028 64.680 64.680 dBizobj.py:694(scanRows)
2 0.000 0.000 64.680 32.340 dBizobj.py:632(getChangedRows)
1 0.000 0.000 64.680 64.680 dBizobj.py:678(scan)
1569 0.052 0.000 63.060 0.040 dBizobj.py:1137(_moveToRowNum)
3142 0.084 0.000 62.860 0.020 dBizobj.py:1316
(setCurrentParent)
3146 0.056 0.000 61.896 0.020 dBizobj.py:2016
(_setCurrentCursor)
3134 0.348 0.000 61.828 0.020 dBizobj.py:142(createCursor)
3134 0.228 0.000 50.867 0.016 dBizobj.py:1929
(_syncCursorProps)
3134 0.080 0.000 47.519 0.015 dCursorMixin.py:2567(_setTable)
3134 0.124 0.000 47.355 0.015 dCursorMixin.py:1964(getFields)
3134 1.856 0.001 46.615 0.015 dbPostgreSQL.py:143(getFields)
3134 6.752 0.002 36.658 0.012 dCursorMixin.py:283(execute)
310266 8.129 0.000 22.933 0.000 dCursorMixin.py:192
(_correctFieldType)
6268 0.120 0.000 11.801 0.002 dConnection.py:47(getCursor)
6268 0.080 0.000 11.581 0.002 dBackend.py:70(getCursor)
6268 0.184 0.000 11.501 0.002 dBizobj.py:193(__init__)
12536 0.108 0.000 11.233 0.001 :0(apply)
6268 0.244 0.000 10.961 0.002 dCursorMixin.py:23(__init__)
6268 0.344 0.000 9.493 0.002 dObject.py:36(__init__)
6268 0.144 0.000 8.389 0.001 propertyHelperMixin.py:49
(_extractKeywordProperties)
6268 3.488 0.001 8.205 0.001 propertyHelperMixin.py:252
(getPropertyList)
3134 3.616 0.001 6.852 0.002 dCursorMixin.py:1090(getDataSet)
209978 3.116 0.000 6.428 0.000 :0(decode)
216246 3.924 0.000 6.004 0.000 dCursorMixin.py:2470
(_getEncoding)
209979 2.048 0.000 3.312 0.000 utf_8.py:15(decode)
342812 3.028 0.000 3.028 0.000 :0(isinstance)
37608 2.812 0.000 2.812 0.000 :0(dir)
3134 0.932 0.000 2.756 0.001 extras.py:57(fetchall)
21938 0.564 0.000 2.752 0.000 dCursorMixin.py:2371
(_getAuxCursor)
404851 2.444 0.000 2.444 0.000 :0(append)
3134 0.044 0.000 2.160 0.001 dCursorMixin.py:2360
(_setAutoPopulatePK)
310266 2.056 0.000 2.056 0.000 extras.py:108(__getitem__)
6276 0.228 0.000 1.840 0.000 dBizobj.py:936
(getParentLinkValue)
103422 1.276 0.000 1.720 0.000 extras.py:104(__init__)
1568 0.020 0.000 1.588 0.001 dBizobj.py:649(_listChangedRows)
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-dev
Searchable Archives: http://leafe.com/archives/search/dabo-dev
This message:
http://leafe.com/archives/byMID/[email protected]
