Atomicorp

I'm having problems with consumption of the CPU and the memory.
What of these options would help me to consume less?


Option #1
Connect to sql server, execute the sql command and disconnect once it is done. And do again for each command.

Option #2
Connect to sql server, execute all the sql commands and disconnect when script dies.


More ideas will be very appreciated.

Thank you

Using a single connection will most likely be more efficient.

However, if you keep the connection open for a long time, without really using it, you will be wasting a tiny bit of memory and an otherwise available connection slot on the database server. If you have a huge amount of concurrent requests this can become an issue.