Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Do you check connection on every call to SQL?
Message
 
 
À
10/03/2012 12:11:45
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01537347
Message ID:
01537936
Vues:
24
>>Not exactly correct, in my case. I do indeed use VFPOLEDB under ASP.NET (without problems) for several years because I use it with VFP data, not SQL Server. And of course, with SQL Server I will be using ODBC.
>
>My reference was in fact related to when I was using it with VFP data as this is the only data adapter capable of doing it from .NET Framework, I believe. This situation has been simulated at Microsoft as well as with another member here. That requires a site with significant amount of hits. If you only have a few hits here and there, you will probably not run into the situation. But, if you respond to 30k to 1 million hits a day, you will get it.

My application does not get that many hits at all; not even close. It works in an Intranet setting for an organization of maybe up to 1000 people. And they don't use it that much. So, I suppose, I am lucky. I am working on completely moving from VFP database to SQL Server. Therefore in the future it won't be an issue.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform