© 2016 Assisi Software Corp

  • LinkedIn - Black Circle
  • YouTube - Black Circle
Jun 15, 2017

SQL Server for local installation

1 comment

We will be running Assisi locally on my PC in order to get the best performance.  You said that we can run this in SQL...will SQL Server Express suffice or is that too limited in its functionality to give us the benefits we're trying to get?

Jun 15, 2017


Hi Paul,

SQL Server Express is fine.  It’s has mostly a full SQL Server feature set, but with database size limited to 10 GB.  My bet is your database will have a maximum of 1 GB with a fully compiled and expanded inventory.  If you start simulating long term plans, then it could get into the multiple GBs.  SQL Express is pretty much perfect for single users wanting a more robust database than MS Access.

For your PC, the most important thing is CPU and SSD speed.  If you partition the SSD into System and Data partitions, then I’d make System 128 GB and the rest Data.

Good luck with the new PC.  It’s always exciting to get an upgrade!


New Posts
  • Wanted to give a quick update on Assisi Cruiser, our upcoming data collector. Our prototype in PowerApps is working OK, but PowerApps has too many restrictions like meant to be online and can only share apps with members of the same computer domain. So now I am also prototyping in Xamarin: the cross platform (iOS, Android & Windows) tool of choice for most serious developers. It's going well and I should have something for others to test soon. Send me a note if you are interested in beta testing! Rich
  • Is is possible to change the BAF in the middle of a cruise?
  • This afternoon we are starting our seasonal inventory cruising program. Radial growth measurement. I would like a 5 year growth measurement. You have a field in Assisi for this, but I don’t see one on the spreadsheet. Just add it before the first segment call?