我在C#中设立了一个方案,在Oracle Express(当地审案)中记录250万份,并增设500万份记录。
我在屏幕上添加了一些密码,似乎相当快。 它每9秒处理1K记录。 这意味着需要6小时以上的时间才能完成。
现在,我与任务主管机构一起看到该方案正在使用66%的CPU(最大)和大约50MB记忆。 我理解,Oracle自己需要资源来运作,但是,......我们有办法告诉这个很少的方案,“它 s、走过头,使用至少50%的CPU,有4GB的RAM如此高的ock子”。
注:使用波拉诺快车的当地案例Im的原因之一是减少网络瓶颈。 而且,我可能无法经常地开展这一进程,但我很抱着眼看,这是否是完全可能的。
请原谅,
感谢!
运行系统将给你的方案提供它所需要的一切资源,因此,你的工作不会耗尽万国邮联的所有费用,可能是因为它比处理员要等待国际交易日志分系统。
如果你想看到你能够消费更多的邮联周期,就试图起草一个方案,该方案将尽可能快地运行一个短的无限通道,而且你将看到邮联使用上的差别。
A number of thoughts, not really answers I guess, but.
您是否担任过这方面的宣传者?
如果目前只读了一件事,你可以看看看看你是否能够将它 par成bat子,从而同时管理。
Without knowing a lot of detail of the splitting of records, is it possible to off hand that more to oracle to do? eg, would matter less about network etc or local or otherwise.
If you re apps drawing/updating a screen or UI then it will almost certainly slow the progress of the work down. An example. I ran an app which sorted about 10k emails into around 250k lines into a database, if I added an item to a listbox each line the time went from short to rediculous eg, crash out got bored. So, again, offloading to a thread to do the work with as few UI updates to do as possible can help.
I am trying to find out the difference between difference service account types. I tumbled upon this question. The answer was because it has powerful access to local resources, and Network Service ...
Does anyone know how to programatically detect that a Windows server is part of a cluster? Further, is it possible to detect that the server is the active or passive node? [Edit] And detect it from ...
I ve read Get File Icon used by Shell and the other similar posts - and already use SHFileInfo to get the associated icon for any given extension, and that works great. However, Outlook uses ".msg" ...
How can I create an empty file at the DOS/Windows command-line? I tried: copy nul > file.txt But it always displays that a file was copied. Is there another method in the standard cmd? It should ...
I know about the GetLastInputInfo method but that would only give me the duration since last user input - keyboard or mouse. If a user input was last received 10 minutes ago, that wouldn t mean the ...
My application creates a thread and that runs in the background all the time. I can only terminate the thread manually, not from within the thread callback function. At the moment I am using ...
Yes, I know, the archive bit is evil. That being said, is there support for querying it with find , and modifying it with chmod ? My googling has turned up nothing......
I built a Java application that is delivered on USB sticks. To ensure compatibility, I ship an appropriate JVM on the sticks. I made an EXE that simply invokes this JVM with the application jar. Now ...
