Obviously, I'm not defining the relation correctly. Here is the query that is generated to pick up one of the fields in "Actions". It's selecting on actions.contact_id. It should be selecting on actions.RECID, the primary key of the actions table, right? I think it's doing a linear search through 11000 records to pick up each field in Actions.
============== SELECT actions.`CALLBACKAT` AS `actions_CALLBACKAT`, actions.`LASTATMPON` AS `actions_LASTATMPON`, actions.`ACCOUNTNO` AS `actions_ACCOUNTNO`, actions.`PREVRESULT` AS `actions_PREVRESULT`, actions.`CALLBACKON` AS `actions_CALLBACKON`, actions.`LASTCONTON` AS `actions_LASTCONTON`, actions.`MEETTIMEAT` AS `actions_MEETTIMEAT`, actions.`COMMENTS` AS `actions_COMMENTS`, actions.`MEETDATEON` AS `actions_MEETDATEON`, actions.`RECID` AS `actions_RECID`, actions.`LASTATMPAT` AS `actions_LASTATMPAT`, actions.contact_id AS actions_contact_id, actions.`NEXTACTION` AS `actions_NEXTACTION`, actions.`LASTCONTAT` AS `actions_LASTCONTAT` FROM actions WHERE %s = actions.contact_id ORDER BY actions.`RECID` --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
