#2325: Indexes not created on foreign keys on auth tables
------------------------+---------------------------------------------------
Reporter: pitrou | Owner:
Type: defect | Status: new
Priority: normal | Milestone:
Component: TurboGears | Version: 2.0b7
Severity: minor | Keywords:
------------------------+---------------------------------------------------
The default-generated auth tables (tg_user, tg_user_group, etc.) contain
some foreign keys, but no explicit indexes on these foreign keys.
PostgreSQL doesn't implicitly create indexes on foreign keys and,
therefore, all joins along these foreign keys will be done as sequential
scans. Explicit Index() declarations should be added in model/auth.py for
each of those foreign keys.
(please note: this is not a problem for most applications where the number
of permissions will be very small)
--
Ticket URL: <http://trac.turbogears.org/ticket/2325>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "TurboGears Tickets" group.
This group is read-only. No posting by normal members allowed.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets?hl=en?hl=en
-~----------~----~----~----~------~----~------~--~---
