recién se me presento un problema explicit, al ejecutar la consulta con Four millones de registros a actualizar
replace Tabla
set so1 = (case when o1 = @nro then true else so1 finish),
so2 = (case when o2 = @nro then true else so2 finish),
so3 = (case when o3 = @nro then true else so3 finish),
so4 = (case when o4 = @nro then true else so4 finish),
so5 = (case when o5 = @nro then true else so5 finish)
the place o1 = @nro or o2 = @nro or o3 = @nro or o4 = @nro or o5 = @nro;
utilizando Ado.web con csharp me arroja una excepción o a veces problemas con un mensaje de problemas COM
utilizing (NpgsqlConnection cnn = new NpgsqlConnection(_strconection))
{
cnn.Execute(consulta1,new {nro=4});
}
creo que debe ser por el tiempo de espera, pero al ejecutar con al pgadmin no tengo problemas, o en que puedo optimizar.
Gracias por adelantado.
Best Quality Private Proxies by Proxyti:
fully anonymous
100% anonymous and safe reliable private proxies
1,000 mb/s speed
Blazing fast proxy servers with up to 1,000 mb/s speed
Elite quality
Best quality proxies from world and USA locations
Unlimited bandwidth
No limits of using your proxies - truly unlimited bandwidth
Buy Now - Get 2X More Proxies:
100 Private Proxies
$30/month
200 Private Proxies
$50/month
500 Private Proxies
$100/month
1,000 Private Proxies
$180/month
2,000 Private Proxies
$340/month
5,000 Private Proxies
$750/month
Our Unbeatable Proxy Features:
Anonymous Proxies
100% security with our proxies – anonymous and secure proxy experience
Ultra Fast Speed
Proxyti offers up to 1,000 mb/s ultra fast proxy speed – feel the real power!
Unlimited Bandwidth
No data limits for your proxies – truly unlimited proxy bandwidth for you!
Proxy Authentication
We secure proxies with IP authentication – use your proxies with your own IP
Elite Quality
Highest proxy quality guarantee with supported HTTP/HTTPS and SOCKS connections
Great Prices
Proxyti offers great proxies for great prices – this is what we call new proxy era!
USA Locations
You can choose USA or random proxies locations when ordering for free
No Limitations
We don’t have any limits – you can use your proxies with every software or program!
Lots Of Subnets
The more proxies you buy, the more subnets you get – it is worth ordering more!
Semi Dedicated
Our proxies are shared with maximum of 5 users at a time, but they are still anonymous
Fast Delivery
We deliver your ordered proxies in your email in .txt file – this is simple as that
Awesome Support
Have any questions or want more information – please contact us anytime!