What's better....??

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi, i got a program running in 10 machines, collecting a pice of data every
10 seconds in each of them... right now, i'm saving these into objects and
serializating them in case of a crashing so i can go back to the point where
the program crashed... i know that instead of serialize the objects into
files i can write directly to the DB and reload from there in case of
trouble... my question is, will 10 machines writing all the time to the DB
(Sql Server) will generate too much traffic into the network?? that's why
at the beggining i implemented this idea... is it good? is it bad? any
suggestion??

Thanks.
Alex.
 
Need more details to give a good answer. Writing to sql server, imho,
should not be an issue with 10 users and would be my preferred method.
Then, you have one central datastore vs. 10.
 
Typically, there is no problem to have 10 users to access the SQL database.
It depends on your environment.

However, it is recommend implement 3 or N-tier structure. For example, you
can run a component, which receives the request from the users and
communicate with the backend SQL server. Then send the results back to the
users.

Sincerely,

Kevin
Microsoft Support

This posting is provided "AS IS" with no warranties, and confers no rights.
Get Secure! - www.microsoft.com/security

--------------------
| From: "Alex" <[email protected]>
| Subject: What's better....??
| Date: Thu, 16 Oct 2003 13:35:11 -0400
| Lines: 14
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| Message-ID: <[email protected]>
| Newsgroups: microsoft.public.dotnet.framework.adonet
| NNTP-Posting-Host: nsc66.147.74-145.newsouth.net 66.147.74.145
| Path:
cpmsftngxa06.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFTNGXA05.phx.gbl!TK2MSFTNGP08
.phx.gbl!TK2MSFTNGP12.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.framework.adonet:63783
| X-Tomcat-NG: microsoft.public.dotnet.framework.adonet
|
| Hi, i got a program running in 10 machines, collecting a pice of data
every
| 10 seconds in each of them... right now, i'm saving these into objects and
| serializating them in case of a crashing so i can go back to the point
where
| the program crashed... i know that instead of serialize the objects into
| files i can write directly to the DB and reload from there in case of
| trouble... my question is, will 10 machines writing all the time to the DB
| (Sql Server) will generate too much traffic into the network?? that's why
| at the beggining i implemented this idea... is it good? is it bad? any
| suggestion??
|
| Thanks.
| Alex.
|
|
|
 
Back
Top