473,326 Members | 2,081 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

makepy, ADO and dynamic.py

I'm trying to track down a performance issue in my Windows code, and
hotshot is telling me that the most time and calls are spent in these
methods

ncalls tottime percall cumtime percall filename:lineno(function)
75975 63982.779 0.842 124464.419 1.638
c:\python24\lib\site-packages\win32com\client\dynamic.py:285(_make_meth od_)
71294 47871.424 0.671 50629.224 0.710
c:\python24\lib\site-packages\win32com\client\__init__.py:444(_ApplyTyp es_)

If I understand correctly, running makepy on the appropriate COM class
should get rid of the dynamic stuff and let it be called directly. I
use ADODB to talk to my database server, and I've run makepy for
"Microsoft Active X Data Objects 2.8 Library" [1] and on "Microsoft
ActiveX Data Objects Recordset 2.8 Library", but I'm still seeing the
call to the dynamic.py class.

Am I right that seeing the calls in "dynamic.py" implies that I'm
running "makepy" on the wrong thing? Any idea what I should be running
makepy on?

[1] I seem to have a bunch of versions of "Microsoft ActiveX Data
Objects Library", is there a chance that another ADO library is being
used?

Sep 9 '06 #1
1 1489

"Chris Curvey" <cc*****@gmail.comwrote in message news:11**********************@i42g2000cwa.googlegr oups.com...
I'm trying to track down a performance issue in my Windows code, and
hotshot is telling me that the most time and calls are spent in these
methods

ncalls tottime percall cumtime percall filename:lineno(function)
75975 63982.779 0.842 124464.419 1.638
c:\python24\lib\site-packages\win32com\client\dynamic.py:285(_make_meth od_)
71294 47871.424 0.671 50629.224 0.710
c:\python24\lib\site-packages\win32com\client\__init__.py:444(_ApplyTyp es_)

If I understand correctly, running makepy on the appropriate COM class
should get rid of the dynamic stuff and let it be called directly. I
use ADODB to talk to my database server, and I've run makepy for
"Microsoft Active X Data Objects 2.8 Library" [1] and on "Microsoft
ActiveX Data Objects Recordset 2.8 Library", but I'm still seeing the
call to the dynamic.py class.

Am I right that seeing the calls in "dynamic.py" implies that I'm
running "makepy" on the wrong thing? Any idea what I should be running
makepy on?

[1] I seem to have a bunch of versions of "Microsoft ActiveX Data
Objects Library", is there a chance that another ADO library is being
used?
The most reliable way to make sure the generated support is used is
to call win32com.client.gencache.EnsureDispatch. If a typelib can
be found, the corresponding python module will be created if it doesn't
already exist.

Roger
Sep 10 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Gerson Kurz | last post by:
I have problems getting "COM makepy" working in ActivePython 2.3.2. This is what happens when I start "COM makepy" from the Pythonwin Menu: PythonWin 2.3.2 (#49, Nov 6 2003, 10:18:20) on...
0
by: Jim Kerr | last post by:
Does makepy always respect versioning of interfaces? It appears as though makepy correctly handles versioning of objects you obtain directly, but not for objects you get via a function call. ...
1
by: Steve M | last post by:
When I use the COM Makepy utility on one computer with WindowsXP, ActivePython 2.3 and I select the library Microsoft Word 10.0 Object Library (8.2), things work fine. When I have WindowsXP,...
4
by: suzhi18 | last post by:
Hallo, I've a problem getting makepy running. When I start the tool on my machine with doubleclick everything is fine. But when I try this in my Code: makepy.py -i "Microsoft Excel 11.0...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.