On Sep 15, 2007, at 1:22 PM, johnf wrote:
> Larry has created a form that is very slow on my Linux box. We
> have been
> trying to fix the performance. During our testing I noticed that
> approximately 40 calls were made to getfields(). Even with the server
> cache - 40 calls take time.
Now you're ready to run the other handy debugging tool: the
profiler. To do this, add:
from dabo.lib.profilehooks import profile
...to the top of your bizobj, and then add the following method
(assuming your bizobj class is named 'BizFoo'):
@profile
def requery(self):
super(BizFoo, self).requery()
Now run your app normally, and when you exit, you should see the
profile output. Paste that into an email if it isn't obvious which
are the slow parts.
> I was able to see the 40 calls by reviewing the Postgres server
> logs. Which
> means that the call was made to the Postgres server and not cached
> by Dabo -
> Right?
Of course, if the server logged it, they had to have been made.
> The log is a little to long to include in the text. I'll send it
> to you.
Try the latest update. I've tried to add some intelligence to
cursors so that if they have already executed a query with the exact
same field list, they don't try to set the field info again.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
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/dabo-users/[EMAIL PROTECTED]
