Ah, much better format than the old Daily News. Thanks Chris.

You've recieved some excellent info from Mycroft. And I agree with him fully. I'd just like to add that memory considerations is a major reason to do the job on the database using SQL scripts. A database is optimised for handling large sets of data. "When did ignorance become a point of view" - Dilbert

treefirmy wrote: Any rationale for either tactic would be greatly appreciated. I'd open it just before the Connection is used, and close it as soon as I'm done with it; Take a look at tip #3 on Connection Pooling[^]. I are Troll :suss:

The key to your argument should be about cost; each cost can then have a technical answer to the question - for example, annual maintenance cost is $500k as we need to employ a team of DBA's to manage 1000's of databases Give your suggested solution with a cost, give his solution with it's associated costs. You can always ham it up a bit to ensure that your solution looks better. This will get his interest far more than technical discussions on the merits or otherwise of solutions.