1

Topic: The optimization decision is necessary

There is a certain operation. At each start of this operation I on basis have 3 requests. This operation should be launched at certain errors and to send the SMS notice. I thought to make in date and time at which error arises and to send SMS - the notification message, besides there is still any a decision of minimum optimization?

2

Re: The optimization decision is necessary

Sneep wrote:

there is a certain operation. At each start of this operation I on basis have 3 requests. This operation should be launched at certain errors and to send the SMS notice. I thought to make in date and time at which error arises and to send SMS - the notification message, besides there is still any a decision of minimum optimization?

Something is turbid in a crystal full-sphere. That you tell as the operating fact, as the future (not working). Thus spread on a tree, but ask a reality...

3

Re: The optimization decision is necessary

MaximaXXL wrote:

it is passed...
Something is turbid in a crystal full-sphere. That you tell as the operating fact, as the future (not working). Thus spread on a tree, but ask a reality...

Well works norms, it is simple if in date and time to adjust that operation it will be launched everyone 5 - 10 seconds. And during the day in basis many requests will arrive and it badly I think. Any else other decision for this purpose) is necessary

4

Re: The optimization decision is necessary

Sneep wrote:

... I thought to make in date and time... To send SMS... Still any the decision of minimum optimization?

Try to send SMS not in date and time, and, for example, through a SMS sluice...

5

Re: The optimization decision is necessary

andrey_anonymous;
Well with sending SMS of problems is not present. Before sending SMS it is necessary to take an amount of errors which it was deduced at document processing and then to send SMS.

6

Re: The optimization decision is necessary

Whether it is possible to store value last Id for example 23452 on any variable on pl/sql and that at new start of operation to compare id if there is that to take> this id?

7

Re: The optimization decision is necessary

Whether

Sneep wrote:

It is possible

RTFM

8

Re: The optimization decision is necessary

wrote:

At present sending procedure is launched each 10 seconds, and it would be desirable, that was launched only when there are errors?

As a variant:
1. To create the table with errors and with a sign - it is sent on SMS or not
2. At entering in it of a new error to launch the job () which forms the message on new errors
3. In this job to mark those lines from item 1 on which we informed

9

Re: The optimization decision is necessary

;
Yes, correctly understood

10

Re: The optimization decision is necessary

MaximaXXL wrote:

Thus spread on a tree, but ask a reality...

, from a word to tick. In the modern Russian it would sound: "Run as fiber on a tree" smile

11

Re: The optimization decision is necessary

Sneep wrote:

Zaggi;
Yes, correctly understood

AQ

12

Re: The optimization decision is necessary

Sneep wrote:

... Operation will be launched everyone 5 - 10 seconds. And during the day in basis many requests will arrive and it badly I think.

Than it is bad?