I've got a huge taxonomy with about 20.000 terms and four hierarchical levels. This taxonomy is associated to a CCK content type.
When I try to save a node belonging to this content typ, this action takes very long (on my local test server several minutes). On my life-server I get the message:

User warning: Lost connection to MySQL server during query query: SELECT * FROM users u WHERE LOWER(name) = LOWER('admin') in /home/www/Travunity/includes/database.mysql.inc on line 172.

I suppose, the saving-action takes a huge amout of time. But I can't understand this, because I'm assuming, that there is only an intex to tte taxonomy, witch needs to be saved. So, what takes such an amount of time??

I already raised max_execution_time to 180 and memory_limit to 70M.

Is there anything I can do?

Comments

ricabrantes’s picture

ricabrantes commented
Status: Active » Closed (fixed)

No activity, Closed

smitty’s picture

smitty commented

I think this is a serious issue. You shouldn't close it without an answer.

Can you explain, what is going on there?

smitty’s picture

smitty commented
Status: Closed (fixed) » Active

Re-opened

ainigma32’s picture

ainigma32 commented
Status: Active » Postponed (maintainer needs more info)

In case this problem still exists and you still want to find the solution I would suggest installing the Devel module. You can then log the queries that are executed. Post the query that is taking up all this time and we'll take it from there.

If this has already been solved please close this issue.

- Arie

catch’s picture

catch
he/him
Primary language English
commented

How many users do you have?

smitty’s picture

smitty commented

@ainigma32: I am still interested in this problem. But at the moment I don't have the time to do the testing. So I'll do it later.
@catch: At the moment less then 20 users, but growing.

ainigma32’s picture

ainigma32 commented

This thread http://drupal.org/node/227445 might be of some help.

Please post back if any of those solutions work for you.

- Arie

ainigma32’s picture

ainigma32 commented

@smitty: Did you manage to find some time to look at this?

- Arie

smitty’s picture

smitty commented

Sorry, this is a huge amount of possible sources and solutions. Because I am verry busy in other tings at the moment I have to postpone the testing.

But thank you very much for the Link. I'll check it later.

ainigma32’s picture

ainigma32 commented
Status: Postponed (maintainer needs more info) » Postponed

I know the feeling. Hope you figure it out when you get around to it.

- Arie

tr’s picture

tr commented
Status: Postponed » Closed (won't fix)

Drupal 5 is no longer supported. If you experience this problem in Drupal 6 or higher and can provide some steps to reproduce the error, please open a new issue.