I'm using Erel's CloudKVS-solution for more than 3 years in one of my projects and it is perfect for our needs. We are using it with up to 120 clients with only small data and it seems, that the server is far below his potential. I now want to provide it for other units. It think, max. 10 units. Each unit has also up to 120 clients. I think, SQLite is completely adequate for our needs, but in all threads over SQlite, my question is not finally answered:
My idea is now, to set up one table for each unit with
and with a server-filter to decide, which table is needed based on the user and password. With this solution, i don't have to touch the old table and we could further use it. Is that a feasible way or do i develop in a wrong direction?
Thanks for help..
My idea is now, to set up one table for each unit with
B4X:
Public Tabelname As String
..
....
sql.ExecNonQuery("CREATE TABLE " & Tablename & " (user TEXT, key TEXT, value BLOB, id INTEGER, time INTEGER, PRIMARY KEY (user, key))")
sql.ExecNonQuery("CREATE INDEX id_index ON " & Tablename & " (id)")and with a server-filter to decide, which table is needed based on the user and password. With this solution, i don't have to touch the old table and we could further use it. Is that a feasible way or do i develop in a wrong direction?
Thanks for help..