Graphics

 View Only
Back to discussions
Expand all | Collapse all

Best practices for a SQL server for DataLinq - Can we run the server on the Xpression Studio box?

  • 1.  Best practices for a SQL server for DataLinq - Can we run the server on the Xpression Studio box?

    Posted 04-18-2014 22:16
    Hi all,

    Would you recommend that we run a SQL server locally on the XPression Studio PC or should the server be run on a separate machine? What are the best practices or recommendations on where to host the SQL server?

    We also have not decided on a flavor of SQL if anyone has any recommendations.

    Our table is a couple thousand rows and a few dozen columns large. Only one user (Xpression) will access it at a time.

    Thank you for your time,


  • 2.  RE: Best practices for a SQL server for DataLinq - Can we run the server on the Xpression Studio box?

    Posted 04-21-2014 18:08
    I would run the database server on a different machine than XPression. It's advisable to install as little extra software as possible on the realtime graphics engine. The datalinq server can then run on either the same machine as the database server, or on the XPression machine.

    Sometimes setting up the database server to allow remote connections can be tricky, and in that case running datalinq server on the same machine is sometimes easier.

    #XPression