Performance Problem when fields from profile Module activated

Hi,

i changed now to the dev version and installed the devel module and logged.

Path Memory (MB) ms (Total) Anonymous? # Queries Query ms
1 13.75 454 No 65 14
admin/reports 19.25 669 No 62 11
1 13.75 455 No 65 17
admin/settings/performance_logging 23.00 1589 No 87 29
admin/settings/performance_logging 12.50 710 No 26 10

The site endet up in an error page.

How can i create an index

regards dave

Hi i cleaered the cache and everything.

for some reason its not logging the queries

and when i load the advanced page it takes ages an then just shows up a blank page ....

Ok

the problem is that i cant look in the 2 log files cause the provider does not seperate them by customer and logs everything of all users.

I asked them now to allocate more memory and how to create an index.

And how stable is the dev oder alpha 1 module cause i need the possibility to search for people without roles and active accounts.

regards dave

Hi got now the instruction how to increase the memory and the side loads now but it takes ages?

How can I create an Index can u tell me that?

regards

Hi they are telling me that there is nothing in that logs and its not slow with them?

thanks for your patience btw :)

I really dont know how i could contribute more information to you?

regards

Hi,

finally they told me what is the slow query.

| Id | User | Host | db | Command | Time | State | Info |
| 7991024 | confi14_admin | localhost | confi14_drupalvm | Query | 139 | Sending data | /* drupal_admin : pager_query */ SELECT COUNT(DISTINCT u.uid) FROM drupal_users u LEFT JOIN drupal_u |

regards

Hi they sended me now the query.

SELECT COUNT(DISTINCT u.uid) FROM drupal_users u LEFT JOIN drupal_users_roles ur ON u.uid = ur.uid

regards

Weired cause its only slow when i activate profile fields ? Any idea why?

Hi thanks for your patience but they are not able to give me the proper query so we wont get whats causing that.

But thx anyway :)

Hi, I'm back sorry for the time it took. But now I know the queries. which cause the problem.

If i run the query directly in phpmyadmin the first takes approximatly 4 minutes and the second 3. But if i start the advacned user module in drupal i get a White Screen of Death.

query1:
SELECT COUNT(DISTINCT u.uid) FROM drupal_users u LEFT JOIN drupal_users_roles ur ON u.uid = ur.uid LEFT JOIN drupal_profile_values profile_company ON profile_company.fid = 11 AND profile_company.uid = u.uid LEFT JOIN drupal_profile_values profile_vorname ON profile_vorname.fid = 1 AND profile_vorname.uid = u.uid LEFT JOIN drupal_profile_values profile_nachname ON profile_nachname.fid = 2 AND profile_nachname.uid = u.uid;

the result of this query is 3224 or sth like that

query2:
SELECT DISTINCT u.uid, u.name, u.mail, u.status, u.created, u.access FROM drupal_users u LEFT JOIN drupal_users_roles ur ON u.uid = ur.uid LEFT JOIN drupal_profile_values profile_company ON profile_company.fid = 11 AND profile_company.uid = u.uid LEFT JOIN drupal_profile_values profile_vorname ON profile_vorname.fid = 1 AND profile_vorname.uid = u.uid LEFT JOIN drupal_profile_values profile_nachname ON profile_nachname.fid = 2 AND profile_nachname.uid = u.uid ORDER BY u.created DESC LIMIT 0, 50;

i hope this information helps

regards dave

index erstellen:

CREATE INDEX IDX_profile_fields ON drupal_profile_fields (fid)
CREATE INDEX IDX_profile_values ON drupal_profile_values (uid,fid)
CREATE INDEX IDX_users ON drupal_users(uid)
CREATE INDEX IDX_users_roles ON drupal_users_roles(uid)

thanks for all of your help this totaly fixed the problem

regards dave