Why does a retrieve of a record from an entity takes less dan 1 second if there are only one or a few child records associated with it, but more than 30 seconds if there are 20.000 child records are associated with it. I'm only interested in the record of the parent, not in his child's associated to My Xpath is based only on one boolean attribute On request, here the log: Nov 5 09:26:54.196 - INFO - Webimport: Start registration 7001106654 Nov 5 09:26:54.241 - INFO - Webimport: Begin webservice 7001106654 Nov 5 09:26:54.305 - INFO - Webimport: End webservice 7001106654 Nov 5 09:27:18.066 - WARNING - ConnectionBus_Queries: (1/40) Query executed in 28 seconds and 487 milliseconds: SELECT "register$crm"."id", Nov 5 09:27:18.066 - WARNING - ConnectionBus_Queries: (2/40) "register$crm"."company", Nov 5 09:27:18.066 - WARNING - ConnectionBus_Queries: (3/40) "register$crm"."address", Nov 5 09:27:18.066 - WARNING - ConnectionBus_Queries: (4/40) "register$crm"."fullname", Nov 5 09:27:18.066 - WARNING - ConnectionBus_Queries: (5/40) "register$crm"."gender", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (6/40) "register$crm"."zipcode_city", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (7/40) "register$crm"."housenumber", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (8/40) "register$crm"."incorrectiban", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (9/40) "register$crm"."commercie", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (10/40) "register$crm"."changeddate", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (11/40) "register$crm"."phone1", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (12/40) "register$crm"."dustbin", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (13/40) "register$crm"."phone2", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (14/40) "register$crm"."housenumberextra", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (15/40) "register$crm"."searchname", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (16/40) "register$crm"."unique", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (17/40) "register$crm"."relationid", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (18/40) "register$crm"."zipcode", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (19/40) "register$crm"."isblocked", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (20/40) "register$crm"."importhelper", Nov 5 09:27:18.067 - WARNING - ConnectionBus_Queries: (21/40) "register$crm"."completecommunication", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (22/40) "register$crm"."ibanmessage", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (23/40) "register$crm"."cocnumber", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (24/40) "register$crm"."bankaccount", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (25/40) "register$crm"."city", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (26/40) "register$crm"."initials", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (27/40) "register$crm"."middlename", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (28/40) "register$crm"."mobile", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (29/40) "register$crm"."mailen", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (30/40) "register$crm"."emailaddress", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (31/40) "register$crm"."completenamerelation", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (32/40) "register$crm"."streetname", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (33/40) "register$crm"."createddate", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (34/40) "register$crm"."kindofcompany", Nov 5 09:27:18.068 - WARNING - ConnectionBus_Queries: (35/40) "register$crm"."lastname", Nov 5 09:27:18.069 - WARNING - ConnectionBus_Queries: (36/40) "register$crm"."system$owner", Nov 5 09:27:18.069 - WARNING - ConnectionBus_Queries: (37/40) "register$crm"."system$changedby" Nov 5 09:27:18.069 - WARNING - ConnectionBus_Queries: (38/40) FROM "register$crm" Nov 5 09:27:18.069 - WARNING - ConnectionBus_Queries: (39/40) WHERE "register$crm"."dustbin" = TRUE Nov 5 09:27:18.069 - WARNING - ConnectionBus_Queries: (40/40) ORDER BY "register$crm"."id" ASC LIMIT 1 Nov 5 09:27:18.331 - INFO - Webimport: End registration 7001106654
asked
Jan de Lange
2 answers
2
Hi Jan,
I think that retrieving an object in Mendix will also retrieve all the object IDs for the associated objects. So it will also retrieve 20.000 IDs.
Perhaps a good idea for the idea forum, to be able to retrieve an object without the association IDs.
Cheers,
Jeffrey
answered
Jeffrey Draaijer
1
For that query, I see little reason for the execution time to be that long. I wouldn't attribute that to the number of children. My suggestion would be to create an index on the boolean and see how that performs.