Which is faster: loading IMG from DB or from Folder

fhiremark · #1 05-13-2006, 09:56 PM

Hello,

My site is pretty heavy on images, and I'm wondering if pages load faster from the database or from the folder.

Also, how do I set X-cart to load images from the folder? - I saw some function pertaining to this in the Admin panel, but I didn't know how to use it.

jeeya · #2 05-13-2006, 10:00 PM

Use Images in File. It will make lot of difference to load site.

fhiremark · #3 05-14-2006, 04:25 PM

Hey raxitpatel thanks for the reply. Can you give me some quick steps or point me to some threads where I can find out how I can make xcart get images from file instead of db.
[/b]

balinor · #4 05-14-2006, 06:21 PM

http://forum.x-cart.com/viewtopic.php?t=11589

fhiremark · #5 05-14-2006, 07:51 PM

Hey balinor, thanks for the thread. I looked it over and the instructions were very clear, however I have problem:

When I switch from DB to FS I notice that the thumbnail images get renamed: t_######.jpg -- which means that a "t_" prefix is added. This is a problem because currently all my pictures are named ######.jpg so when the script runs I get all "FAILURES" because the program can't find the image.

I think I would have to go manually rename about 1300 images just to add the "t_" prefix for this to work, surely there has to be a way around this. Do you know it?

I would have posted this in the thread you sent me but it wouldn't let me, so hopefully you can help me out here. --Thanks

Audiolines · #6 05-19-2006, 04:30 PM

just download your ###### images, grab a program from www.download.com that batch renames files, add the t_ and you are done,

should take 5 - 10 mins from download to upload of renamed files.

now, from here on out, all new ones will have t_

jackel · #7 05-21-2006, 01:50 AM

If you are using Windows, just use the Command line option:

ren /?
Renames a file or files.

RENAME [drive:][path]filename1 filename2.
REN [drive:][path]filename1 filename2.

this command also allows for Batch renaming, or if you feel like it, you could write a Batch Script to do this.

Hope thats of use to you.

fhiremark · #8 06-16-2006, 07:13 PM

Hey thanks for the replies jackel and Audiolines,

Had I known there was such a way to batch edit file names, I would've saved myself a ton of time when I was tinkering with another project of mine. I'm glad I found this out now though, I still haven't got to chance to change this feature on my xcart yet.

Thanks guys