Something that we implemented for our Data Access Layer to improve performance with UniObjects.NET was a custom connection pool (before IBM released connection pooling in UniObjects.NET) and in that connection pool, all the idle connections were kept active for a specified time, and had a "heartbeat" that opened a specific file and read a record from it every few seconds..
It worked quite effectively, but we have now updated to using the IBM connection pool.. the theory however remains.. Build a controller that handles the opening, allocation, un-allocation, idling, reallocation and closing of a connection to the backend. Then the process would be as simple as requesting a "new" connection from the Controller, which would either create a new connection, or allocate an existing but idle connection. Then when you are finished with the connection, you relinquish control of that connection back the Controller, which idles the connection for a specified amount of time for easy reuse before closing it if it is not re-requested... Ray -----Original Message----- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jonathan Leckie Sent: Tuesday, April 21, 2009 12:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Uniobjects Is it possible to keep a Uniobjects connexion open? Or is it possible to have a trigger that would allow an event that could allow the state change to be seen and re-opened? ************************************************************************ * This message has been scanned for viruses and dangerous content by * Blairs Email Server, and is believed to be clean. * * This email and any files transmitted with it are confidential and * intended solely for the use of the individual or entity to whom they * are addressed. * * If you have received this email in error please notify us at Blairs, * details can be found on our website http://www.blairsltd.co.uk * * Name & Registered Office: * -------------------------- * Blairs Limited * 9 Baker Street * Greenock * PA15 4TU * Company No: SC132926 * VAT No: 554698690 ************************************************************************ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/