TOLOGIX - ISLG Maintenance

Project dealing with all ongoing maintenance of the current ISLG application (www.investorstatelawguide.com and dev.investorstatelawguide.com).

Slow loading times for subscriber management page

Assigned to
Anil Vaghela Anil V. Harsh Parikh, Tech Lead at DevIT Harsh P. Ryan Knuth, Customer Support Manager at Industrial Ryan K.
Notes
Further to the video below, I noticed that the loading times for the subscribe managements pages have slowed down tremendously over the last few days. Before we perform the migration for all the to-do's in this group, is there a quick fix we can make to speed up the loading times? I don't want this problem to prevent us from performing the migration tomorrow, but we'll need to address this either before or after the migration.


Comments & Events

Morgan Maguire, CEO
Hi Harsh Parikh, Tech Lead at DevIT Harsh and Anil Vaghela Anil ,

Just confirming that the slow loading times on dev.islg have carried through to www.islg. Please ensure this is resolve as a high priority.

Thanks,

Morgan 
Harsh Parikh, Tech Lead at DevIT
Hi Morgan Maguire, CEO Morgan and Ryan Knuth, Customer Support Manager at Industrial Ryan ,

We have found that due to column  # Logins  the Subscriber Management page takes so much time to load.

Due to complex SQL query, the page takes so much time to populate the #logins data. 

We have improved the  SQL query logic and tried to reduce the loading time on dev.islg. But, The page is still taking some time to load.

We are suggesting that remove the #login column from Subscriber Management page and display inside Session Information modal window or somewhere else.

Please suggest. 
Morgan Maguire, CEO
Understood. Get rid of # of Logins then, and migrate through to www.islg.
Harsh Parikh, Tech Lead at DevIT
Hi Morgan Maguire, CEO Morgan ,

We have removed #logins column from subscriber management page on both dev.islg and www.islg.

Please check and confirm. 
Morgan Maguire, CEO
Looks good Harsh Parikh, Tech Lead at DevIT Harsh . Thank you.

Subash Kuttan Subash , Liam Murphy-Burke, Strategic Account Manager at ISLG Liam and Marysia Raptis Marysia , please take note we needed to remove the # of Logins column from the Subscriber Management table, because it was the primary cause for the slow down.

Thanks,

Morgan
Morgan Maguire, CEO
Morgan Maguire completed this to-do.