vBGarage 4.0.0 FS mode Vs. DB mode

vBGarage now has two operating modes. FS or file system mode and DB or database mode. Both modes store full size and thumbnail images in the respective place.

In the previous version of vBGarage images were thumbnailed on the fly. We found in testing that this method was putting an enormous load on the server when five images of 200k to 250k were displayed as the latest uploads all at once. Even on a board with images limited to and below 64k we saw the usage shoot way up.

After some research the answer seemed to be static thumbnails created at the time of upload. The reasoning being that you will have far fewer uploads then displays.

The justification is that even 1000 images with a 5K thumbnail only add 5 MB of usage to the FS or DB. Thumbnails are usually smaller though, so the overhead is probably exagerated in the above example.

Which mode will be best for your site is a subjective matter.

Please use this thread to discuss pros and cons of each mode. This will be a good way to determine which is best for your site. The number of images per garage and the size of images is a consideration of this equation as well.

the only "safe" version of file archiving is a Files System, because databases tend to grow and if an image is uploaded with a bug in the characters, you will trash your database when backuping... -- occured to more than one of my clients with the profile picture stuff.

also, file system is quite efficient if you talk about saving space... you can locate the directory elsewhere than on the local hd, so if you have a HD crash, not all files are lost.

also, db backups are minimised if you have a load of users using this system...

[noppid]

There's alot to be said about that statement and most of it is why the file system storage now exists.

[cinq]

I think regardless of the pro and cons of either the FS or DB storage method, providing both the options leaves the choice to use either up to the user

Personally, I would use the FS.
This is from my experience using vbGarage 3.1.1 with loads of images and with the DB method and my DB is getting really big and making DB backups a PITA.

[noppid]

Yes, we know what you want. In fact I'm sure it's your asking for it that got it done.

So officially, I'd say chiq inspired FS mode.

[Rick Sample]

I have a quick question for you guys: I just upgraded to vbgarage 4.1.0 and another coder and I have managed to get our garage fully custom, we're not even close to being done, but the major additions are competed. Its running in database mode with vbgarage 4.1.0 Right now we only have a couple hundred megs or so left on our server space.

When we get our new dedicated machine, we will have hundreds of gigs, so we will have enough room for file mode!

My question: Is their a way to upgrade 4.1.0 database mode to 4.1.0 file safe mode? If so, is their also a way to do it so it doesn't update the templates or anything so we can keep our custom vbgarage??


http://www.muscle-mustangs.com/forums/vbgarage.php Again, we still have to add: garage views, number of rides, number of images, and custom view garage, With all of those upcomming changes and the changes we already made to the garage, loosing all of that would be terrible. Thanks for any and all help

[noppid]

There is a utility in the package to move images and thumbs from the DB to the file system.

I forgot to post it. It will move the images without affecting anything else.

[Rick Sample]

Originally Posted by noppid

There is a utility in the package to move images and thumbs from the DB to the file system.

I forgot to post it. It will move the images without affecting anything else.

Nice! Where could I find this script at?? Thanks!

[noppid]

I posted it in the release here. https://vborg.vbsupport.ru/showthread.php?p=610640

[shane801]

If I store my images in fs mode in an images folder in my root, would anyone be able to browse my images file by going directly to www.my_site.com/my_gallery_images?

How would I prohibit this?