File Storage & Preformance
 

From a customers view of things, is it better to have all your images stored in the database or in a directory. Is one faster than the other? What are the pros and cons of each?

My database size is not limited in size but I have no idea if my database preformance is fast or slow or how to find out.

Just looking for a little direction.

Mike :-)

Re: File Storage & Preformance
 

I have found that images in FileSystem is better.

Better performance and much easier to manage.

Re: File Storage & Preformance
 

No contest, Filesystem is a HUGE differene

Re: File Storage & Preformance
 

I have tried several times to switch from database to file system tonight and every time I get a failed in the log file. My ISP gives the following for my html directory name:
/hsphere/local/home/myname/mywebsite.com
this is what I have entered in path to images on local server:
/hsphere/local/home/philken/kennedyhardware.com/catimages

The directory is there and the chmod is set to 777. Any ideas as to what I am doing wrong??

Re: File Storage & Preformance
 

The images should be in the files/ directory by default. So your path would be:

/hsphere/local/home/philken/kennedyhardware.com/files/

I usually put sub-categories in there (cats, dets, thumbs) so it would be:

/hsphere/local/home/philken/kennedyhardware.com/files/thumbs

Make sure the .htaccess file in the files directory says "allow from all' as well. Good thread here:

http://forum.x-cart.com/showthread.php?t=8438

Re: File Storage & Preformance
 

I walked through the other thread and followed the various directions.
When I transfered the .htaccess file I made over to the directory I got an upload success on two different ftp programs but neither one will show the file in the directory.

I also tried to change the chmod on the files folder and got the following error:
/xcart/files - Unable to change permission, file has different UID (398)

I am still getting failed on all attempts to switch to file system

Re: File Storage & Preformance
 

Disreguard the last post. I don't know what changed but it all transfered this last time.

Thanks for the help Padraic. :-)