Re: Storing data periodically on remote server

carmelo wrote:
On 7 Ott, 18:10, "Peter D." <pete...@xxxxxxxxx> wrote:
On Oct 7, 6:25 am, carmelo <csa...@xxxxxxxxxx> wrote:

Hi everybody,
I have to develop a java application to send every 10 seconds a tuple,
made of 3-4 fields, to a remote server. I thought to proceed in this
way:
- server side: mysql dbms (for storing clients transmitted data)
- client side: java application which makes an odbc connection to the
remote mysql db
The expected workload is quite high, in fact, there will be about 100
clients, each of them send data on time interval of 10 seconds.
Do you think is it a good solution?
Thank you very much
Carmelo
I don't know if connecting to the DB directly is a good idea. I would
recommend creating a web service to accept the data instead. The
client will connect to the web service and send the info. The server
side web service will then connect to the DB and do what it needs to
do.

With a web service you can even give your clients the option of coding
their own solutions with any language. Also, it gives you free reign
on your DB server since the web service will abstract it from the
users. If you want to change DBMS you just need to modify the web
service and not every single client.

I think providing a standard web service interface is the way to go.

Thank you for your interesting reply.
But, do you think that using web services will cause problems having
100 clients which connects to the server every 10 seconds? Because
using web services it will be more flexible, but I'll have another
layer...

What do you think about?

10 web service calls per second is not a big load either.

But it will use much more CPU than the JDBC call (think x10-25).

Arne
.

Relevant Pages

  • Re: How do Large Scale Web Service Applications Maintain Session State?
    ... cache these profiles on the server in order to increase performance. ... which is something different than stateful Web Service classes. ... We do pass a session token as ... Having systems deployed through web services allows clients to access via ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: interprocess comms in local network
    ... Server needs to be an application with buttons and menus as it will need to ... I also need to set up permissioning such that only clients that I've ... > ASP.NET provides support for implementing a web service. ... > If IIS was installed when you installed the .NET Framework, ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Web service Performance
    ... clients are using it to synchronize some datas from clients database to ... server database, so they are calling web service methods very often. ... everything is restarting and queries response are going ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Storing data periodically on remote server
    ... made of 3-4 fields, to a remote server. ... clients, each of them send data on time interval of 10 seconds. ... recommend creating a web service to accept the data instead. ...
    (comp.lang.java.programmer)
  • Re: Server Time Out
    ... could be not passing user credentials to the web service from the client. ... calling a remote server from a web server due to not being able to forward ...
    (microsoft.public.dotnet.framework.aspnet.webservices)