Requirements

Classic Servoy
1

Hi

Can anybody give ahint about the minimum requirements to run the SQL Anywhere server and the Servoy Application Server in a useful way, related to memory, harddisk space, CPU? No of parallel users around 50.

Thanks, Robert

2

The key ingredients to this are:

  • your app
  • the performance your users expect

I have seen Servoy servers on 10 year old machines serving 100 users with no problems but also 20K$ servers starting to choke when user number 10 hit the server. In the latter case some serious programming errors were made (eg runnning SQL statements in unstored calcs in a large tableview)

Assuming you have an average (transaction wise) and correctly built system 50 users should run happily on a low end server. Eg

  • dual core cpu
  • 2 gb ram, 1gb assigned to Servoy
  • disksize 4x your expected database size

If you want more speed throw first more RAM at it followed by a speedier disk, eg SSD’s make databases very snappy and happy.

3

Hi Jan

Thanks for your reply, very welcome! Is your answer already based on using SQL Anywhere 11? Is there really a real world advantage (speed wise) using SQL Anywhere 11 vs version 10, as I heard here and there. We will use SQL Anywhere 11 when we are going to roll out our app, so it would be interesting to hear how much faster this version is, like 2%, 20% or may be double as fast :-) Currently, we are still developing on Servoy 4, and yes I know Servoy 5 offers many desired features …

Best regards and merry christmas, to all of you, Robert

PS: Jan, we also asked for the SSL version in this thread (viewtopic.php?f=5&t=13439) and would be very happy to hear an answer, as we are preparing an offer which asks for the SSL version (and must be ready beginning of january). Thanks.