Hello Marc,
I made a quick test with one of the examples that come with the LabVIEW Database Connectivity Toolkit. In a loop I repeatedly called the command
insert into inserttable (querytype, device, numsamples) values ('sql query', 'mydevice', 1872)
writing data to an Access database. The time I need for one iteration is varying slightly with an average rate of 2 or 3 ms. This rate is not influenced by rightclicking and opening context menus.
But since the Database connectivity toolset is using ADO as well I guess the problem is not to be found in the database access itself but somewhere else.
I find it strange that you say the loop time is increasing if you are opening a context menu. Are you stopping any processes by rightclicking that? What processes could that be? This would be the only explanaition I can think of right now. Are you using a lot of frontpanel objects? I would advice to have a look at your VI performance to see in which SubVIs use most processing time.
Ingo Schumacher
Systems Engineering Manager CEERNational Instruments Germany