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&data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650847010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=u3JgbHvI%2F%2BjMoj6cSZE6hskDtx3uQe3otSbSj2rQSP8%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fnmmusd.org%2F&data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650847010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=u3JgbHvI%2F%2BjMoj6cSZE6hskDtx3uQe3otSbSj2rQSP8%3D&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&data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650847010%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=u3JgbHvI%2F%2BjMoj6cSZE6hskDtx3uQe3otSbSj2rQSP8%3D&reserved=0<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fnmmusd.org%2F&data=04%7C01%7CTMSUSERS%40si-listserv.si.edu%7Cb0412877d42a4a46d6cd08d973d57ecb%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637668183650857004%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C2000&sdata=aB6%2FhDuhkXCWNWasIwSYicKhQl2X0mRtoHKA%2BP7WLCk%3D&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.