Lightroom: Speed up database operations

  • 2
  • Idea
  • Updated 2 years ago
  • (Edited)
Please see https://forums.adobe.com/message/9064007#9064007 for background on this.

I found that when I used the "File:Export as Catalog..." command to export my entire catalog, database operations like delete from a static collection have sped up approximately 300-fold. I haven't tested, but I suspect other operations also have become much more snappier.

I ran "Optimize database" on my old database on a nearly daily basis, so obviously, an Export optimizes a database in a different way.

Adobe should figure out what is going on, and offer this (even if it is an Export as Catalog behind the scenes) as a way to speed up database operations.

I will archive my old and new databases, in case you want to examine them.
Photo of Alan Harper

Alan Harper

  • 440 Posts
  • 86 Reply Likes

Posted 2 years ago

  • 2
Photo of Sreenivas Ramaswamy

Sreenivas Ramaswamy, Employee

  • 27 Posts
  • 12 Reply Likes
Hi Alan,

can you share the catalogs as zipped files via drop box or something else ? You can also mail me to sramaswa@adobe.com. I can send you a link where you can upload the files.

Thanks
Photo of Alan Harper

Alan Harper

  • 440 Posts
  • 86 Reply Likes
Thank you, Sreenivas. I have sent you the link privately.