Question: I'm running SalesLogix v6.2 (I know, OLD version), and it doesn't have
many customizations but the database is large. We just turned on
ticketing capabilities, and the ticket window takes 60-90 seconds to
open. I ran the SLX Profiler and discovered the following:
SELECT A1.ATTACHID,
A1.DESCRIPTION, A1.USERID, A1.ATTACHDATE, A1.FILESIZE, A1.TICKETID,
A1.FILENAME FROM ATTACHMENT A1 WHERE A1.TICKETID = ?
This snippit seems to ask for a ticket ID and on initial load
isn't getting one. Instead we're getting well in excess of 320,000 rows
returned over the better part of a minute. I have no idea how to solve this. Any suggestions?
Answer: This is probably happening because of the Attachments tab on the Ticket
Mainview. Unbid the bindid on the form to keep it from loading when the
form loads. After you do this you could put a hidden textbox on the
form that is bound to the Ticket.TicketID, and then add an event to the
OnChange of
the control that sets the bindid property of the grid to the text
property of the textbox. Setting the bindid should load the data.