+1-888-365-2779
Try Now
More in this section

Forums / General Discussions / SiteFinity and MySql

SiteFinity and MySql

6 posts, 0 answered
  1. Praveen Kumar
    Praveen Kumar avatar
    5 posts
    Registered:
    30 Nov 2009
    23 Jan 2011
    Link to this post
    I am really confused now. I am planning to use SiteFinity. But, the choosing the backend between MySql and MS Sql Server having confusion. I need to develop the site for non-profitable organization and they need CMS enabled web site with low cost. Could you please suggest me what could be the good back end system to use?
    1. I know Sql Server has better flexibility than MySql.

    But, MySql is completely free. Whereas MsSql we can use express edition but it comes with 4GB limitation. So, any information like what could be the problems if I use MySql?  Any information will be greatly appreciated.
  2. Gabe Sumner
    Gabe Sumner avatar
    440 posts
    Registered:
    09 Sep 2007
    23 Jan 2011
    Link to this post
    Hey Praveen,

    Is this for Sitefinity 4.0?  I ask because you posted this to the Sitefinity 3.x forums, but Sitefinity 3.x supports MySQL.

    Sitefinity 4.0 [currently] only supports flavors of MS-SQL, although we plan to re-add support for other databases in future releases.

    To get to the point though;  there isn't a magic solution.  Although, MS SQL databases can be added to a lot of shared hosting accounts for a reasonable price.  In the case of DiscountASP.net, these databases are available for $10/month.

    BTW, if SQL Express is an option, feel free to use it.  4GB is a lot of storage space.  Here is a question I posted to StackOverflow a long time related to this subject:

    http://stackoverflow.com/questions/180537/sql-express-for-production

    Cheers,

    Gabe Sumner
    Telerik | Sitefinity CMS

      
  3. Praveen Kumar
    Praveen Kumar avatar
    5 posts
    Registered:
    30 Nov 2009
    24 Jan 2011
    Link to this post

    Thanks for the fast reply. 

    I am using 3.x version only not 4.0. And I knew both backends well. 

    4GB is huge but, in long run it may give problems. The logging and if content is adding then it grows rapidly. 

    Can you please let me know, once again are there any problems with MySql with Sitefinity?

    One more thing is, they have server available. No hosting required. 

  4. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    24 Jan 2011
    Link to this post
    Hi Praveen Kumar,

    There should be no problems using MySQL with Sitefinity 3.x. We have clients having large databases, more than 1 GB on MySQL. One thing that I can advise you is to set your libraries to store content on the file system instead in the database, as MySQL may have problems with returning large data results.

    Regards,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  5. Praveen Kumar
    Praveen Kumar avatar
    5 posts
    Registered:
    30 Nov 2009
    25 Jan 2011
    Link to this post

    What do you mean by this?

    "One thing that I can advise you is to set your libraries to store content on the file system instead in the database, as MySQL may have problems with returning large data results."

    store content on file system means? which content? all the data or files like images/videos etc?

    -Praveen.

  6. Gabe Sumner
    Gabe Sumner avatar
    440 posts
    Registered:
    09 Sep 2007
Register for webinar
6 posts, 0 answered