External Email - Exercise Caution
Fatima, There are many things that can affect the speed of the database. One factor is the amount of wire and the quality of the wire between you and the database server. Another factor is the hardware on the workstation. Is it the same people that are complaining about TMS being slow? Where are their offices located relative to the server, and could their workstations use more RAM?

If some people are reporting slowness when performing certain tasks, then the issue might be related to the queries involved. Some queries take longer to return results because of the number of joins or functions involved, especially if sorting is involved. There are some techniques that can improve these queries, such as adding a few institution specific indexes to the database to improve performance. This is an entire field devoted to performance optimization, and I will not even pretend to know all about it.

If everyone is reporting slowness, then the issue is probably with your database server. Do you have enough RAM? (SQL always wants more RAM!! It is a memory hog!!!) How big are your log files? Large logs take longer to open and write to; truncating these logs may improve performance. Sometimes bouncing the server is enough, because this will return memory to the system, as well as end any zombie processes that might be occurring.

I doubt that uninstalling and reinstalling the client would do much, but I find that something simple like that can have a placebo effect. But if some of these simple fixes don't work - you might want to meet with your IT team and discuss contracting a Microsoft Certified Database Administrator to give your database server a checkup.


On Thu, Sep 9, 2021 at 4:17 PM Mahdi, Fatima <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
Hey, Chad!

Just a question on a not-very-related topic -- Have you ever known uninstalling/reinstalling TMS to help with the glacial speed issues that some users experience?

Cheers,

Fatima

--

Fatima Mahdi
Collections Information Specialist/TMS

Virginia Museum of Fine Arts
200 N. Arthur Ashe Boulevard
Richmond, VA 23220-4007
Tel. 804.340.1443
Pronouns: she/her/hers

[log in to unmask]<mailto:[log in to unmask]>

I acknowledge that I live and work on the ancestral homelands of the Chickahominy, Pamunkey, Mattaponi, and Upper Mattaponi tribes of central Virginia. I offer my deepest respect for their resilience and continued stewardship of their culture.

On Thu, Sep 9, 2021 at 3:53 PM Chad Petrovay <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
Rodger, I have never experienced the issue that you are reporting; but since you are reporting it across your userbase on multiple workstations, I think the problem may be localized to your network setup. It might be how your network delivers the images to TMS; for instance, TMS might be timing out because it is not receiving image data fast enough.

I am going to assume that your images are stored on a network drive. If you are not doing so already, you might want to try converting a media path from a mapped drive letter path to a UNC path. See if that improves access to those images.

Something else to try is uninstalling the TMS client, restarting the workstation, and then reinstalling the TMS client. This can occasionally help.

On Thu, Sep 9, 2021 at 2:21 PM Kelly, Rodger S <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
In general I have always found TMS to be buggy regarding images. It often crashes when we open an image, regardless of your starting point. We experience this on multiple workstations; it’s just that we notice it more from Lightbox since certain staff tend to work with that more frequently.

RODGER KELLY
Deputy Director of Operations  /  TMS (The Museum System) Administrator
National Music Museum
University of South Dakota
414 E. Clark St., Vermillion SD 57069
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fnmmusd.org%2F&amp;data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650847010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&amp;sdata=u3JgbHvI%2F%2BjMoj6cSZE6hskDtx3uQe3otSbSj2rQSP8%3D&amp;reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fnmmusd.org%2F&amp;data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650847010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&amp;sdata=u3JgbHvI%2F%2BjMoj6cSZE6hskDtx3uQe3otSbSj2rQSP8%3D&amp;reserved=0>
[log in to unmask]<mailto:[log in to unmask]>
(605) 658-3442

From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Chad Petrovay
Sent: Thursday, September 9, 2021 12:22 PM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Light Box view crashing

External Email - Exercise Caution
Those specs shouldn't be a problem. Does the system crash whenever you open the image from the object record, or is it just the lightbox? Is this happening on multiple machines or just one?

On Thu, Sep 9, 2021 at 12:08 PM Kelly, Rodger S <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
Jpegs, in the 300 KB to 700 KB range. 800 x 600 pixels. 96 dpi.

From: The Museum System (TMS) Users <[log in to unmask]<mailto:[log in to unmask]>> On Behalf Of Chad Petrovay
Sent: Thursday, September 9, 2021 10:45 AM
To: [log in to unmask]<mailto:[log in to unmask]>
Subject: Re: Light Box view crashing

External Email - Exercise Caution
What are the dimensions, size, and filetype of the image you are trying to open?

On Thu, Sep 9, 2021, 10:38 Kelly, Rodger S <[log in to unmask]<mailto:[log in to unmask]>> wrote:
External Email - Exercise Caution
Hello everyone.

We often experience TMS crashing, then closing, when we click to enlarge an image displayed in light box view.

We are on TMS 2017 (version 9.60.6010_001).

Any ideas what might be causing this, or if it’s a bug with this version?
Thanks and have a great day.
Rodger


RODGER KELLY
Deputy Director of Operations  /  TMS (The Museum System) Administrator
National Music Museum
University of South Dakota
414 E. Clark St., Vermillion SD 57069
https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fnmmusd.org%2F&amp;data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650847010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&amp;sdata=u3JgbHvI%2F%2BjMoj6cSZE6hskDtx3uQe3otSbSj2rQSP8%3D&amp;reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fnmmusd.org%2F&amp;data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650857004%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&amp;sdata=aB6%2FhDuhkXCWNWasIwSYicKhQl2X0mRtoHKA%2BP7WLCk%3D&amp;reserved=0>
[log in to unmask]<mailto:[log in to unmask]>
(605) 658-3442


To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.
To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.



To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email:

signoff TMSUSERS

// eoj

You will receive a confirmation that your subscription has been removed.

To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email:

     signoff TMSUSERS

     //  eoj


You will receive a confirmation that your subscription has been removed.