#32 retrieving objects with multiretrieve is very slow

[Marcos Flavio de Oliveira]

Dear Richard,

I'm using now the version 2.1 of Atomsframework. When
I'm retrieving objects using a multiretrievecriteria is very
slow.

In Visual Studio Output window appear the lines for each
object:

retrievePrivateObject: ServidorDadosFuncionais
retrievePrivateObject: Not cached - generate SQL
@p1: 06433
SELECT t1.MAT_CNEN AS t1_MAT_CNEN,
t1.LOTACAO_ULOC_UFUNC AS
t1_LOTACAO_ULOC_UFUNC, t1.UNIDPAG AS
t1_UNIDPAG, t1.DT_OCUPACAO AS
t1_DT_OCUPACAO, t1.SIT_SERV AS t1_SIT_SERV,
t1.E_MAIL AS t1_E_MAIL, t1.STATUS_SGD AS
t1_STATUS_SGD, t2.SIT_SERV AS t2_SIT_SERV,
t2.DESC_SITUACAO_SERV AS
t2_DESC_SITUACAO_SERV FROM
(Pessoal.dbo.SERV_DADOSFUNC as t1 LEFT JOIN
Pessoal.dbo.SITUACAO_SERV as t2 ON t1.SIT_SERV
= t2.SIT_SERV) WHERE t1.MAT_CNEN = @p1
Select statement returned 1 row(s)
Cache - adding Negocio.ServidorDadosFuncionais
object with keys:
1) System.String: 06433
retrievePrivateObject: ServidorSituacao
Cache - getting ServidorSituacao object from cache.
Key...
1) System.String: 01
- returning copy of object ServidorSituacao
retrievePrivateObject: retreived from cache
Cache - getting ServidorSituacao object from cache.
Key...
1) System.String: 01
- returning copy of object ServidorSituacao
Cache - replacing existing
Negocio.ServidorDadosFuncionais object in cache with
keys:
1) System.String: 06433
Cache: ObjectsLoading turned off so now resetting
m_originalobject for all cache entries

The class Servidor has a subclass
ServidorDadosFuncionais with retrieveautomatic=true.
Each retrieve spends much time. It doesn't appear in
version 2.0.

[Richard Banks]

Logged In: YES
user_id=253192

Hi Marcos,

Thanks for the post - I'll look into it and see what I can find.

[Richard Banks]

Logged In: YES
user_id=253192

Hi Marcos,

I've been having a look through the code and nothing jumps
out at me as a problem.

The framework is only hitting the SQL database once
(according to the debug output you posted). Is the actual
SQL itself slow, or are there many SQL statements being
executed?

Do you think you could post the code you are using, and the
mapping so I could try and duplicate it (or post a unit test
that duplicates it).

[Richard Banks]

Logged In: YES
user_id=253192

Just checking if this is still a problem.

If there's no response in 7 days I'll close this item.