Android Question Save Tcp connections in DB ( MS SQL or MySQL )

alimanam3386 said:

I know I can keep those array of connections in a map but if amount of connections was for example 20K or more what happen ?

Can I save connections ( not just id of users ) in db ? ( I want to save AsyncStreams of users in db )

Click to expand...

Erel said:

Connections <> data, you cannot save connections in a database.

How are you implementing the server?

Click to expand...

Sub Process_Globals
    Private fx As JFX
    Private MainForm As Form
    Private Server As ServerSocket
    Private Clients As Map
    Private uId As Int= 0
End Sub

Sub AppStart (Form1 As Form, Args() As String)
    MainForm = Form1
    MainForm.RootPane.LoadLayout("Layout1") 'Load the layout file.

    Server.Initialize(10733 , "Server")
    Server.Listen

    MainForm.Show
End Sub

Sub Server_NewConnection (Successful As Boolean, NewSocket As Socket)
    If Successful Then
        Dim client As AsyncStreams
        client.Initialize(NewSocket.InputStream , NewSocket.OutputStream , "Client")
        Clients.Put(uId , client) ' save current new connection to map
        uId = uId + 1
        Server.Listen ' Listen for next connection...
    End If
End Sub
.
.
.

Erel said:

The Map can hold millions of objects (or more).

I recommend you to use jServer for real server solutions. It will be much more powerful and reliable.

Click to expand...

Dim ws1 = clients.Get("uId_Here") As WebSocket ' <--------  this line how long takes to get the client object ?
ws1.RunFunction("client_Function" , Null)

alimanam3386 said:

so if we hold 1-10 millions connection in the Map object it can handles all of them, right ?

Click to expand...