8/23/2025 3:27:45 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Troublesome SQL in SLX Ticketing on V6.2
Posted: 13 Mar 08 9:04 AM
|
Currently we are running version 6.2(.6), our system isn't heavily modified but we have a mid to large sized database. We have just activated ticketing out of the box and it's taking clients 40-90 seconds to open the ticket window. After digging through whats ran with SLX Profiler I turned up this gem:
SELECT A1.ATTACHID, A1.DESCRIPTION, A1.USERID, A1.ATTACHDATE, A1.FILESIZE, A1.TICKETID, A1.FILENAME FROM ATTACHMENT A1 WHERE A1.TICKETID = ?
This friendly little snippit seems to want 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've dug everywhere and we had the help of a contractor digging everywhere, so now I'm genuinely stumped. We changed the navbar button to open in details view and still we get it. If anybody has any ideas where to tackle this I'd be greatly appreciated. (I can say the SQL disappears in later versions of SLX so someone, somewhere, must have noticed this.)
Thanks,
-Chris |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|