Kayako logo
SupportSuite, eSupport and LiveResponse Discussion, troubleshooting and feedback related to Kayako's flagship support desk products SupportSuite, eSupport and LiveResponse.

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  (#1) Old
jnet Offline
Member
 
Posts: 574
Join Date: Mar 2008
attachment in database or folder recommend? - 04-04-2008, 05:41 PM

Guys what is good about having attachment in database?
which one do you recommend and why

thanks
   
Reply With Quote
  (#2) Old
Jamie Edwards Offline
Operations Manager
 
Jamie Edwards's Avatar
 
Posts: 5,660
Join Date: Jan 2006
Location: United Kingdom
04-04-2008, 05:42 PM

The file system is the best place for attachments, but it is not as easily portable (i.e. when you move your database, you also move all of your files).

The reason the file system is a preference is because it takes a load off of the database itself, and is inherently more reliable.


Jamie Edwards (jamie.edwards ]at[ kayako.com)
----------------------------------------------------------------
---
   
Reply With Quote
  (#3) Old
jnet Offline
Member
 
Posts: 574
Join Date: Mar 2008
04-04-2008, 05:46 PM

Thanks Jamie
done the setting
   
Reply With Quote
  (#4) Old
supportskins Offline
Senior Member
 
supportskins's Avatar
 
Posts: 3,953
Join Date: Aug 2006
Location: Mumbai, India
04-04-2008, 05:55 PM

I completely agree, file system is a much better option than database!



Professional and Affordable Kayako Skins - Specialists in Kayako Skinning & Customization - Professional Paid Support
Our Skins and Services - http://www.supportskins.com/store/
SupportSkins.com - http://www.supportskins.com/
   
Reply With Quote
  (#5) Old
remsys Offline
New Member
 
Posts: 10
Join Date: Jul 2005
05-04-2008, 08:55 AM

What happens if someone change storage from MySQL to filesystem ?
Would be old attachments still accessible?
If not, is there a migration tool ?
Thanks.


www.remsys.net - server management solutions
   
Reply With Quote
  (#6) Old
craigbrass Offline
Senior Member
 
Posts: 5,920
Join Date: Jun 2005
Location: Cumbria, UK
05-04-2008, 09:26 AM

Old attachments are still accessable but remain in the database. Kayako need to make it so all current attachments are moved when you switch between these options.


Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member)

Icon Headquarters - Its Elixir - Web2Messenger
   
Reply With Quote
Reply

Tags
attachment, database, folder, recommend

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Display no. of tickets in on hold folder (similar to the open folder) jasonwood SupportSuite, eSupport and LiveResponse 1 28-02-2008 04:16 PM
attached files in database or folder? mopa How do I? 1 13-12-2007 08:10 PM
Attachment Storage - Database or Files Directory markh SupportSuite, eSupport and LiveResponse 5 17-07-2007 02:02 PM
Database Stored Attachments johnham Wont Implement / Already Implemented 0 04-10-2006 12:11 AM



Powered by vBulletin® Version 3.7.5
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
Help desk software by Kayako.


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48