Performance BO


Author
Message
Malcon M. Mikami
Malcon M. Mikami
StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
Ola Ivan, estou com uma dúvida, para a inserção de muito registro seguidos oque voce recomenda usar o BO ou criar no codigo sem a verificação. Explico.

Estou populando minha aplicacao com registro para ver a performance dos formularios. Achei estranho que apos um insert no banco o BO faz 2 buscas passando por parametro a PK e outra sem parametro. Isso é normal?

Porque ele faz essas 3 pesquisas apos a inserção?

Em anexo esta um pedaço do SQL Profile com a sequencia de comandos que ele executa.

Attachments
seq.txt (149 views, 9.00 KB)
Malcon M. Mikami
Malcon M. Mikami
StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)StrataFrame Novice (104 reputation)
Group: Forum Members
Posts: 60, Visits: 1.3K
I have a question for the insertion of very record you followed what recommends the use of BO or create the code without verification. Explain.

I populated my application to register to see the performance of forms. I found it strange that after an insert in the bank BO 2 is to parameter searches through PK and another without parameters. Is that normal?

Because he makes those 3 polls after the insertion?

In this annex a piece of SQL Profile with the sequence of commands that it runs.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search