Greetings, I've got a django installation with 259,535 auth_user records, (not that many), but the admin is running REALLY slow.
The user index pulls up fast, but when I click a record to see it in detail, it takes forever and ever! In fact, I haven't been able to get an individual record to display yet (firefox starts to hang). Furthermore, every other model (e.g PersonalityProfile) that has a ForeignKey(User) exhibits the same behavior. If I comment out the ForeignKey(User) in the model, then records for that model open quickly. For whatever reason, the auth_users table is painfully slow. To test my database I tried joining the two tables. I can execute a join from auth_user to profiler_personalityprofile at the mysql prompt and get a result quickly. But again, the admin is slow. Has any one else seen this? Does any one know a possible solution? Thanks much -- matthew mysql> select count(id) from auth_user; +-----------+ | count(id) | +-----------+ | 259535 | +-----------+ mysql> show index from auth_user; +-----------+------------+----------+--------------+------------- +-----------+-------------+----------+--------+------+------------ +---------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | +-----------+------------+----------+--------------+------------- +-----------+-------------+----------+--------+------+------------ +---------+ | auth_user | 0 | PRIMARY | 1 | id | A | 266071 | NULL | NULL | | BTREE | | | auth_user | 0 | username | 1 | username | A | 266071 | NULL | NULL | | BTREE | | +-----------+------------+----------+--------------+------------- +-----------+-------------+----------+--------+------+------------ +---------+ 2 rows in set (0.00 sec) mysql> select * from auth_user u, profiler_personalityprofile p where p.creator_id = u.id order by u.id desc limit 10; ...snip... 10 rows in set (3.74 sec) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
