Sep 1, 2015 Replies: 5 I ran some tests to check whether the Raspberry Pi 2 can be suitable for server solutions. The tests were similar to the tests previously done on a PC: https://www.b4x.com/android/forum/threads/server-performance-measures.37502/#content The database used in the tests is a SQLite database. As explained here the journal mode should be set to wal: [WebApp] Concurrent access to SQLite databases Note that you need to use sqlite-jdbc-3.8.10.2.jar. The journal mode will not be set successfully with the version that currently included with B4J (3.7.2). You can download it here: https://bitbucket.org/xerial/sqlite-jdbc/downloads You can use the code I posted here to check the journal mode: https://www.b4x.com/android/forum/t...-files-wal-shm-not-created.47559/#post-364131 The results are: Simple handler that writes some text as the response: >600 requests per second. Handler that reads a random record from the database (based on the primary key): >600 rps. Same handler in single threaded mode: 400 rps. Handler that inserts a record in 10% of the requests (and reads a record in the other requests): 300 rps. Same as the above with 50% inserts: 100 rps. 100% inserts: 50 rps. Based on these results a Raspberry Pi 2 can be a good option for a powerful (and low cost) back-end solution. Click to expand...
I ran some tests to check whether the Raspberry Pi 2 can be suitable for server solutions. The tests were similar to the tests previously done on a PC: https://www.b4x.com/android/forum/threads/server-performance-measures.37502/#content The database used in the tests is a SQLite database. As explained here the journal mode should be set to wal: [WebApp] Concurrent access to SQLite databases Note that you need to use sqlite-jdbc-3.8.10.2.jar. The journal mode will not be set successfully with the version that currently included with B4J (3.7.2). You can download it here: https://bitbucket.org/xerial/sqlite-jdbc/downloads You can use the code I posted here to check the journal mode: https://www.b4x.com/android/forum/t...-files-wal-shm-not-created.47559/#post-364131 The results are: Simple handler that writes some text as the response: >600 requests per second. Handler that reads a random record from the database (based on the primary key): >600 rps. Same handler in single threaded mode: 400 rps. Handler that inserts a record in 10% of the requests (and reads a record in the other requests): 300 rps. Same as the above with 50% inserts: 100 rps. 100% inserts: 50 rps. Based on these results a Raspberry Pi 2 can be a good option for a powerful (and low cost) back-end solution.
andymc Well-Known Member Licensed User Longtime User Sep 1, 2015 #2 Wow! Nice to see it works so well. An RP2 could be perfect for a home hosted game server for storing online score boards or game saves. (or obviously much much more)
Wow! Nice to see it works so well. An RP2 could be perfect for a home hosted game server for storing online score boards or game saves. (or obviously much much more)
Cableguy Expert Licensed User Longtime User Sep 1, 2015 #3 I am in the workings of gathering the Hardware part for my 4hdd pi2B based server
TomDuncan Active Member Licensed User Longtime User Sep 9, 2015 #4 Have been running my web server for a few days now. No problems and comments from others on the speed. Positive ones at that. So happy chap. Tom
Have been running my web server for a few days now. No problems and comments from others on the speed. Positive ones at that. So happy chap. Tom
desof Well-Known Member Licensed User Longtime User Nov 17, 2015 #5 It is possible with a raspberry and a development something like this? https://lh3.ggpht.com/eHRRenkgxkGweMKSWlLI2p5_3nOEFB2eLG3S8AEVjWYIXaYSwnTLoQWvq6LihCbN=h900
It is possible with a raspberry and a development something like this? https://lh3.ggpht.com/eHRRenkgxkGweMKSWlLI2p5_3nOEFB2eLG3S8AEVjWYIXaYSwnTLoQWvq6LihCbN=h900
Erel B4X founder Staff member Licensed User Longtime User Nov 17, 2015 #6 This is not the correct place to post this question.
