https://sourceforge.net/p/adodbapi/feature-requests/8/2014-07-14T17:45:12.597000ZRecent changes to 8: Use of Win32Com Cache2014-07-14T17:45:12.597000Z2014-07-14T17:45:12.597000ZGeorgehttps://sourceforge.net/u/georgeukrr/https://sourceforge.netcd8b02febe69afecb360f1c4e113fa93dcba587d

<div class="markdown_content"><p>Could there be a way to specify that you want to use EnsureDispatch (and hence pre-build the Com scripts)?</p> <p>I've modified adodbapi.py to...</p> <div class="codehilite"><pre> <span class="n">def</span> <span class="n">Dispatch</span><span class="p">(</span><span class="n">dispatch</span><span class="p">)</span><span class="o">:</span> <span class="n">win32com</span><span class="p">.</span><span class="n">client</span><span class="p">.</span><span class="n">gencache</span><span class="p">.</span><span class="n">is_readonly</span> <span class="o">=</span> <span class="n">False</span> <span class="k">return</span> <span class="n">win32com</span><span class="p">.</span><span class="n">client</span><span class="p">.</span><span class="n">gencache</span><span class="p">.</span><span class="n">EnsureDispatch</span><span class="p">(</span><span class="n">dispatch</span><span class="p">)</span> </pre></div> <p>And this has resolved problems I was having with dynamic.py from win32com taking up a lot of resources. The program I'm building uses thousands of short queries so the overhead really adds up.</p></div>