On Wednesday, April 2, 2014 8:39:01 AM UTC-5, schapm...@gmail.com wrote: > I am attempting to provide a bit of data through a com server I did a > comparison of speed of my COM interface to ADODB and It seems massively > slower. I'm not sure if there is something I need to adjust or maybe that I > am making so many calls to the COM server that each call takes time and > possibly ADO is just buffering some data in chunks to my code. This is > mainly for an excel add-on that has not possibility to connect to mongodb > except through an interface like this. > > > > I thought it was not really a big deal until I tested larger amounts of > data and the speed took a nose dive. For instance 10,000 records just to > walk through and pull a couple fields. ADO on the exact same data took only > 1.5 seconds where my python code took close to 58 seconds to do the same > thing. I've played around with design etc. > > > > When i test the same code directly from python I get the same result if not > better than I did with ADO. Is there some bit of COM magic that I am > missing. Or is this because python is having to do more behind the scenes? > > > > Thanks
Hi, Did you implement your server using win32com? You might be better off looking for help on the python-win32 mailing list [1]. Regards, Chris [1] https://mail.python.org/pipermail/python-win32/ -- https://mail.python.org/mailman/listinfo/python-list
