Database Storage vs. File Storage in Shopp

by Lorenzo Orlando Caum on September 10, 2011

The Shopp Plugin offers two storage options: Database and File System.

In this post, we’ll be looking and the pros and cons of each option.

In general, choosing between the two will should depend on the long-term goals of your Shopp e-commerce store. If you will be only selling a few products / services and plan for limited growth, then database storage may be ideal for you.

Reviewing Database Storage in Shopp

✓ No set up required for ‘Image Storage’
✓ No set up required for ‘Product File Storage’

- Uploads are limited to 2MB (Can be increased with a combination of WordPress & PHP edits)
- As the database grows in size, your website performance declines ↘
- Backing up a large database requires more work and time

If you plan to grow your Shopp e-commerce store and become a dominant player in your niche, you’ll need to plan for growth. In this case, you should go with File System storage.

Looking at the File System Storage in Shopp

- Requires an initial set up for ‘Image Storage’ (creating folder and assigning proper permissions)
- Requires an initial set up for ‘Product File Storage’ (creating folder and assigning needed permissions)

✓ Upload limit issue is resolved. You can upload large files (MB – GB) via FTP and attach them to products. Smaller files can still be uploaded via the Shopp interface
✓ Easy file backups
✓ Database will maintain its performance due to limited growth in size

If you are still unsure about which option is best you for, opt for File System. After all, it will grow with your needs.


Related Posts Plugin for WordPress, Blogger...

This post was written by...

– who has written 11 posts on Optimize My Shopp.

@lorenzocaum is an entrepreneur and a marketer.

Lorenzo contributes to the Shopp project as a customer support rep.

He is the founder of Enzo12 LLC, a web engineering firm in Tampa, FL. He also has a business, marketing, and technology blog.

Previous post:

Next post: