Vb.Net Windows应用程序中来自Oracle的大数据超时问题 [英] Timeout issue with large data from Oracle in Vb.Net Windows aplication

问题描述

HI，

我在Vb.Net应用程序中遇到了有关超时的怪异问题.该应用程序将针对屏幕上的大量上传数据及其处理而构建.

一切正常，但是我面临20K数据处理的问题.我已经测试了15K数据及其完美的工作性能.

我必须调用oracle Stored proc作为创建参数的最后步骤，步骤如下所示，

1.将数据从登台表复制到主表

2.将ID返回页面.

第一步正在发生，但是每当我在屏幕上收到超时"消息(检查数据库表)时，都可以确定所有数据处理都已完成，不确定为什么数据没有返回屏幕.尽管这发生在15000条记录中.

我正在使用.Net 4.0版本和Web服务进行数据库连接.

请指教.

谢谢和问候，

Aniket

I am facing a weird issue with the Time-out in the Vb.Net Application. The application is to be built for the Mass Upload data on the screen and processing of the same.

All the things are working fine, but I am facing problem with 20K data processing. I have tested with 15K data and its working perfect.

I had to call a oracle Stored proc for the final steps to create the parameters and the steps are as below,

1. Copy the data from a staging table to the main tables

2. Return the ID to the page.

the 1st step is happening but every time I am getting Time-out message on the screen, Checking on the DB tables, can find out that all the data processing is done, not sure why the data is not returning to the screen. Though this is happening for 15000 records.

I am using .Net 4.0 version and web services for the database connectivity.

Please advice.

Thanks and Regards,

Aniket

推荐答案

阅读: http://stackoverflow .com/questions/12692832/commandtimeout-for-oraclecommand [ ^ ]

http://stackoverflow.com/questions/12660636/oraclecommand-timeout [ http://docs.oracle.com/cd/B28359_01/win.111/b28375/OracleCommandClass.htm#DAFBGECA [ ^ ]

Read this : http://stackoverflow.com/questions/12692832/commandtimeout-for-oraclecommand[^]

http://stackoverflow.com/questions/12660636/oraclecommand-timeout[^]

http://docs.oracle.com/cd/B28359_01/win.111/b28375/OracleCommandClass.htm#DAFBGECA[^]

HI，

我增加了Web服务的超时并解决了该问题.它以前没有工作，但后来又工作了.

谢谢，
Aniket

I have increased the timeout of the web service and resolved the issue. It was not working earlier but later worked.

Thanks,
Aniket

这篇关于Vb.Net Windows应用程序中来自Oracle的大数据超时问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！