One of the most critically important features in DriveWorks is the ability to get data into, and out-of other systems, which is why we provide a whole slew of ways of doing so.
Of these, QueryData is perhaps the most used due it's relative simplicity (compared to, say, GetData).
The problem is, QueryData is not without its own troubles, indeed, if you have a large implementation with quite a lot of queries being performed, you can quickly notice that things start to drag.
The reason for this is quite simple, every call to QueryData opens a connection to the target database, gets the data, and closes the connection again. With database servers such as Microsoft SQL Server, Oracle and the likes, the set-up and tear-down of the connection is quite an expensive operation, and something to avoid wherever possible.
Quite late in the development cycle for SP2 we put together a solution for this which involves re-using connections, unfortunately it was too late in the day to ship this with SP2 and there are still improvements that we would like to make.
However, due to the significant performance improvements that can be obtained, and because another service pack is not planned for release for some months yet, we're making this version of QueryData available as a macro.
I've created a page to explain how to obtain and use this new macro, and also explain how it works, so, if you are currently finding data access is slowing down your implementation, please take a look.
I'm really interested to hear about your mileage with this new QueryData macro, so please, if you find the time, drop me an e-mail and let me know how it works out for you. It would also be really great if you have any rough timing comparisons for before and after using it.
Did this make it into SP3?
Posted by: Jeff Sweeney | Saturday, 20 October 2007 at 04:17
No - the aim for SP3 was to ensure interoperability with SP2.1 and focus on performance and quality.
This feature will however make it into our next service pack when it is released.
Posted by: Philip Stears | Saturday, 20 October 2007 at 12:43