Disconnected databases
C#
1
Posts
1
Posters
0
Views
1
Watching
-
I realise we are supposed to open and close database connections when required rather than leaving a connection open but doing so kills the performance of my app which is a high speed database analysis tool. I do a lot of ExecuteScalar and ExecuteReader statements and opening and closing the connection every time seriously impacts the performance. Is there something I am unware of to make it faster?