Hi, I am actually trying to integrate MonetDB with an old SQL Server application using SQL CLR integartion. The CLR function calls a C++ dll which uses the mapi interface. Since I can't hold state in the CLR, I have to reconnect to MonetDB for each call. There may also be concurrent calls from SQL Server, which means I think I need a new connection context for each call. Best Regards Matthew ________________________________________ Hi On 22/01/14 15:29, Matthew Russell wrote:
Hi all,
I am writing a simple C++ dll which uses the mapi interface to connect to MonetDB.
The query itself runs extremely fast which is fantastic. I did notice that the mapi_connect() takes approximately 1 second to connect on my machine on a local socket.
Is there anyway to improve this connection latency? I can't unfortunately use a connection pool or keep the connection open due to the design of the calling application. Assuming you connect using SQL, then most likely not. The user session environment has to be set up first, which calls for quite some administrative tasks.
To further be of advice, we should know more about the application setup/specifics. regards, Martin
Best regards,
Matthew Russell
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list