Some suggestions: 1) Check your temp folder and remove chaff.
2) Download CCleaner and check your registry integrity. 3) Review updates that have been applied and try removing them one at a time or in a targeted fashion. You should be able to see what updates were applied around the time you think Lightroom went bad. (At the start menu type Update in the search box and select "View installed updates"). 4) Have a look at Lightroom using Process Monitor and perhaps Performance Monitor. Maybe the process has a high number of threads, or files in use, or handles or something like that. 4) Install Windows Performance Toolkit and try xperf or Windows Performance Analyzer to profile Lightroom and try to see what is taking up time. 5) Turn off Avast shields for a while and see if that makes a difference. 6) Stop/Disable the Windows Search service temporarily and see if that makes a difference. -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Mark Romero Sent: Wednesday, April 1, 2015 3:17 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Did A Recent Windows & Update Affect SQLite??? Hello everyone and thanks for your replies (I am new to using a mailing list so I hope that everyone gets this response). - Viruses and Antivirus software: I use Avast in real time and I have scanned my system several times and it came up clean. I installed malwarebytes shortly after Lightroom began having problems, and the scans came up clean, too. (I have since uninstalled malware bytes.) Have not tried any of the native Microsoft virus tools. - Software Updates: I am using the latest version of Lightroom (5.7.1) I am using Win 7 Pro 64-bit Service Pack 1 and I am pretty sure it is up to date since I do automatic updates with it. - CPU Usage: In resource monitor and task manager, it is ONLY lightroom that is using up all the CPU and is "spiking" the cpu (it repeatedly and rhythmically goes from 50% use to 100% use over and over again. It spikes approximately every 5 seconds or so. No other program or process is using an abnormally large percentage of CPU (or memory) Please also note that when Lightroom IS spiking the CPU, I am still able to open other programs (like Photoshop, which is something of a resource hog), and work in those programs, WHILE Lightroom is spiking the CPU. To rephrase this, when lightroom stops responding I can go ahead and open photoshop and work on a different photo, with only minimal lag compared to when Lightroom is not spiking the CPU. - Hard Drive (and other hardware): I have used the Dell diagnostic tests and the Western Digital tests and they have all been fine for the hard drive as well as ALL other hardware. - Disk Performance / File corruption Yes, I have seen NTFS errors in the event manager. But they only seem to happen when Lightroom has stopped responding and I chose to do a ctrl-alt-del instead of doing a ctrl-q and waiting for the program to eventually close. (I know that ctrl-alt-delete is bad... will try to avoid again!) I have done another chkdsk and it came out fine, and I did a chkntfs and it came out saying C: is not dirty. - Tech Support from Adobe: I have had THREE separate Adobe technicians login remotely to my computer and make changes to different settings, and unfortunately it has not made a difference. Because the program stops responding sporadically, they will make a few changes and then ask me to try it. If the problem doesn't happen within five minutes, they end the chat and say, "It's probably ok, let us know if you have problems in the future." Then five minutes after they end their support chat and log out of my system, it will stop responding again. The changes they have made include increasing the cache, giving adobe programs "resource priority" . they also tried to update my drivers but I don't know if they were able to update or not. - Reinstallation: I have deleted and reinstalled Lightroom 5.7.1 once already after the problem started a few months back, and unfortunately it did not make a difference. - Lightroom versus Adobe Camera Raw (ACR) Someone pointed out that Lightroom is different than ACR, and that is true. However, I spend most of my time in the Development module of Lightroom, which is (as far as I understand) extremely similar to ACR. Just so you know, I can use ACR ALL DAY LONG without any problems. My understanding is that Lightroom saves info to its SQlite database, while ACR saves info to a separate file. One Other Fun Fact: A lot of people are dismissive of my problem because I have an older computer (core 2 duo E8400 with 8 gigs DDR3 RAM). "Just buy an i7" they like to chant. However, Lightroom worked fine for over 8 months until just about two months ago, when the problems started, and... My sons computer has the same problem, which developed at the same time. Again, worked fine for 8 months, then BAM! It started having the problem too. However, it happens A LOT LESS on my son's computer, and his computer is even LOWER SPEC'D than my computer (He has a C2D E4500 with only 4 Gigs DDR2 Ram) The main thing we have in common is that we both have Win 7 64 bit (his computer has ultimate, I have Pro). Thanks in advance for any other thoughts or suggestions. On Wed, Apr 1, 2015 at 6:05 AM, Donald Griggs <dfgriggs at gmail.com> wrote: > Regarding: "... would love to see the SQLite schema Lightroom uses" > > Hi, Rob > > I am not a user of Lightroom, but there's a start at this link: > > > http://www.earthboundlight.com/phototips/querying-sqlite-lightroom-dat > abase.html _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users --- This email has been checked for viruses by Avast antivirus software. http://www.avast.com
