我应该为服务器客户端选择哪种方法 [英] Which method should I choose for server client

问题描述

我已经开发了c＃win app

这个应用程序运行在差不多20个客户端机器上

并且所有客户端只在单个数据库中在LAN服务器机器上读写数据。

服务器操作系统是Windows Server 2008 R2数据中心。我安装了ms sql 2005快递版。



现在我的问题是：



1） 20个客户在单个数据库中工作，所以性能是否有任何问题？

或我应该为所有客户创建个人数据库以提高性能？



2）我要担心的主题（在服务器/客户端）



3）如何建立网络？与工作组或域名的帮助。

如果域名比如何建立域名？



i am newbe所以请详细描述。



提前帮助:)



我尝试过：



i还没有尝试任何东西，因为这是我的第一个项目，我必须建立服务器/客户端连接。

i have devloped c# win app
this app is runs on almost 20 client machine
and all clients are read and write data in LAN server machine in only single database.
server os is windows server 2008 R2 datacenter. and i installes ms sql 2005 express edition on it.

now my problem is :

1) 20 clients work in single database so is there any problem with perfomance ?
or i should create personal database for all client to increase perfomance ?

2) what topics i have to worry about (in server/client)

3) how to establish network ? with workgroup or help of domain.
if domain than how to establish domain ?

i am newbe so please describe in detail.

thanx for helping in advance :)

What I have tried:

i have't try any thing yet becuause this is my first project in which i have to made server/client connection.

推荐答案

这是一个很难的问题，因为你并没有真正提出一个问题。你问的问题主要是广泛而深刻的问题，需要大量的知识来了解你的确切情况 - 我们都没有。



1）如果您可以为每个客户端使用个人数据库，然后是，这可能会有更好的性能（取决于各个PC）但是......使用基于服务器的系统和多个独立数据库之间存在根本区别是：

This is a difficult one, because you're not really asking one question. And the questions you are asking are mostly really broad, deep questions which need a huge amount of knowledge of your exact circumstances - none of which we have.

1) If you can use "personal database" for each client then yes, that is possibly going to have better performance (it depends on the individual PCs) BUT... there is a fundamental difference between using a server based system and multiple stand alone databases which is:

Individual databases don't talk to each other

这意味着您的用户不会在他们之间共享信息 - 这是基于服务器的系统的整点！

如果您在SQL Server上有20个用户，那可能是因为您希望帐户中的Janice能够查看Sales中的John已添加到Customer 1234的帐户中的内容。你不能用个人数据库做到这一点。



2）一切。远远不是甚至可以从这里开始。有关于这个主题的全书 - 很多 - 我建议你得到一些好的SQL server / C＃书籍并仔细阅读。



3 ）不要担心。它可能不重要（你有更大的鱼可以先煎炸）。

Which means that your users don't share information between them - which is the whole point of a server based system!
If you have twenty users on SQL Server, then that's probably because you want Janice in accounts to be able to look at what John in Sales has added to Customer 1234's account. And you can't do that with individual databases.

2) Everything. Far, far to much to even begin here. There are whole books on the subject - lots of them - I'd suggest that you get a couple of good SQL server / C# books and read them carefully.

3) Don't worry about it. It's probably not going to matter (you have much bigger fish to fry first).

这篇关于我应该为服务器客户端选择哪种方法的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！