Follow us on Twitter X-Cart on Facebook Wiki
Shopping cart software Solutions for online shops and malls
 

File Storage & Preformance

 
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design
 
Thread Tools Search this Thread
  #1  
Old 08-26-2006, 05:20 PM
  hoosierglass's Avatar 
hoosierglass hoosierglass is offline
 

X-Adept
  
Join Date: Aug 2006
Location: Zionsville, IN
Posts: 974
 

Default 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
__________________
X-Cart Gold 4.7.7
Custom Work from www.luminointernet.com
www.indy-pen-dance.com
Reply With Quote
  #2  
Old 08-26-2006, 06:39 PM
 
Light Speed Light Speed is offline
 

X-Adept
  
Join Date: Mar 2003
Posts: 921
 

Default Re: File Storage & Preformance

I have found that images in FileSystem is better.

Better performance and much easier to manage.
Reply With Quote
  #3  
Old 08-26-2006, 06:52 PM
 
balinor balinor is offline
 

Veteran
  
Join Date: Oct 2003
Location: Connecticut, USA
Posts: 30,253
 

Default Re: File Storage & Preformance

No contest, Filesystem is a HUGE differene
__________________
Padraic Ryan
Ryan Design Studio
Professional E-Commerce Development
Reply With Quote
  #4  
Old 08-26-2006, 08:24 PM
  hoosierglass's Avatar 
hoosierglass hoosierglass is offline
 

X-Adept
  
Join Date: Aug 2006
Location: Zionsville, IN
Posts: 974
 

Default 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??
__________________
X-Cart Gold 4.7.7
Custom Work from www.luminointernet.com
www.indy-pen-dance.com
Reply With Quote
  #5  
Old 08-27-2006, 03:57 AM
 
balinor balinor is offline
 

Veteran
  
Join Date: Oct 2003
Location: Connecticut, USA
Posts: 30,253
 

Default 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
__________________
Padraic Ryan
Ryan Design Studio
Professional E-Commerce Development
Reply With Quote
  #6  
Old 08-27-2006, 07:24 AM
  hoosierglass's Avatar 
hoosierglass hoosierglass is offline
 

X-Adept
  
Join Date: Aug 2006
Location: Zionsville, IN
Posts: 974
 

Default 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 (39

I am still getting failed on all attempts to switch to file system
__________________
X-Cart Gold 4.7.7
Custom Work from www.luminointernet.com
www.indy-pen-dance.com
Reply With Quote
  #7  
Old 08-27-2006, 07:31 AM
  hoosierglass's Avatar 
hoosierglass hoosierglass is offline
 

X-Adept
  
Join Date: Aug 2006
Location: Zionsville, IN
Posts: 974
 

Default 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.
__________________
X-Cart Gold 4.7.7
Custom Work from www.luminointernet.com
www.indy-pen-dance.com
Reply With Quote
Reply
   X-Cart forums > X-Cart 4 > Dev Questions > Changing design



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -8. The time now is 09:24 AM.

   

 
X-Cart forums © 2001-2020