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!
|
|
Listview is stuck with loading
Posted: 29 Jun 10 6:28 AM
|
I'm having some problem with an environment whereby if you goto a contact group in list view the system just gets stuck loading it. System will stay on this screen and never loads the contacts into the list view.
Has anyone else seen/heard of this. Its only a contact group of 300 or so contacts so should load nice and quickly! |
|
|
| |
|
Re: Listview is stuck with loading
Posted: 29 Jun 10 10:43 AM
|
It appears that the Loading is timing out before the SQL returns the Data to load the group.
If this is happening to all groups it may be due to Performance/Locks on your SQL DB.
Use SLX Profiler and/or SQL Profiler to try and determine why your query is not returning in a timely matter.
|
|
|
|
Re: Listview is stuck with loading
Posted: 30 Jun 10 3:49 AM
|
It appears to run the folloing SQL and really has a problem executing it, I have tried running it in SQL management studio and it just runs and runs and isn't completing. It seems to do this for new groups that I am creating because I can select adhoc groups that already exists and then open up correctly.
SELECT
COUNT(A1.CONTACTID)
FROM
sysdba.CONTACT A1
INNER JOIN sysdba.SECRIGHTS S_AA ON (S_AA.ACCESSID = 'U6UJ9A000061' AND A1.SECCODEID = S_AA.SECCODEID )
INNER JOIN sysdba.ADHOCGROUP A4 ON (A1.CONTACTID=A4.ENTITYID)
INNER JOIN sysdba.ADDRESS A3 ON (A1.ADDRESSID=A3.ADDRESSID)
INNER JOIN sysdba.ACCOUNT A2 ON (A1.ACCOUNTID=A2.ACCOUNTID)
INNER JOIN sysdba.SECRIGHTS S_AB ON (S_AB.ACCESSID = 'U6UJ9A000061' AND A2.SECCODEID = S_AB.SECCODEID )
WHERE A4.GROUPID = 'p6UJ9A00056Z'
|
|
|
|
Re: Listview is stuck with loading
Posted: 30 Jun 10 7:24 AM
|
Check for Locks at the time that you are executing this.
Also, I would suggest you review your Indexes and Statistics on your Database. Make sure all SLX Indexes are in place.
Also, Analyze the query using the Estimated Execution plan, and try adding indexes to determine where the slow down is taking place.
|
|
|
| |
| |
|
Re: Listview is stuck with loading
Posted: 06 Jul 10 9:23 PM
|
Same suggestion:
Run SLX or SQL Profiler, gather the Queries being executed and try to determine how to Improve it (Add indexes as needed, if indexes in place, rebuild them, rebuild Statistics, etc) |
|
|
|