Adobe has a whole set of procedures to troubleshoot Lightroom. One of their recommendations is:

  • Close Lightroom.
  • Close all your other programs.
  • Restart Lightroom while no other program is running.

There are 2½ major reasons:

  1. There may be not enough memory to run all the applications concurrently with Lightroom. Lightroom is a “memory hog”. Then your computer will have to swap the memory, slowing down Lightroom so much that it looks like it’s frozen.
  2. There may be not enough CPU cycles to run all the applications concurrently with Lightroom. Lightroom is a “CPU hog”, slowing down Lightroom so much that it looks like it’s frozen.
  3. The third reason applies mostly to the Mac version. Many programs on the Mac platform also run the SQLite database, just like Lightroom. There are so many versions of SQLite floating around. In Feb-2009, SQLite.org has announced its latest version: 3.6.11. Depending on your version of Lightroom, the oldest version of SQLite that I know of is: 3.1.3. They can conflict with each other, introduce and/or fix bugs. Usually the latest version of SQLite wins, and it may not be Lightroom’s version of SQLite.

There are very few SQLite based programs on the Windows platform. Adobe AIR and Lightroom are some of the very few programs that use SQLite and run on Microsoft Windows platform.