I'm currently upsizing a FoxPro app to SQL server. I created a Datatier that connect to SQL server. I was wondering, should I use a SQL connection handle for every instance of my Datatier or should it be better to have a Global SQL connection handle that I would reuse?
I see it more flexible to have a different handle per Datatier instance, this way, If I wanted, I could connect to table from multiple different SQL Servers.
The only negatif effect is that if I open 160 tables per user, I would have 160 connections per user on my SQL Server. Would this have an impact on performance or on the server itself?
Luc Nadeau
lnadeau@neova.ca"the theory, it is when all is known and that nothing works. The practice, it is when all works and that nobody knows why." - Albert Einstein (Nobel of physique 1921)