Noob关于独立，单用户应用程序中的数据库工作的问题。 [英] Noob questions about database work in stand alone, single user app.

问题描述

<！ - @page {margin：0.79in} P {margin-bottom：0.08in} - >

这里有一些菜鸟问题。我是一个五十岁的人，很长一段时间没有做太多的编程。我正在构建我认为可以称为独立的，本地数据库，使用Visual Basic的单用户应用程序。我的问题涉及数据库工作，我很少有经验。这个应用程序将有一个捆绑的数据库，到我完成时可能有十万条记录。每条记录最多可包含100条数据。我将以MS Access格式获得大部分数据。大多数数据库查询都是非常基础的。我大约在我的Visual Basic书籍的一半（由Murach提供）并且还没有进入数据库的东西，但我想要你们的反馈。到目前为止，VB的内容对我来说非常清楚。我可能不会在几个月内编写任何数据库内容。我的问题是：

 

Visual Basic本身是否足以处理这种数据加载，还是会太慢？ LINQ会有帮助吗？

 

我是否应该使用SQL Server进行数据库工作，或访问，或。 。 。 ？

 

我打算购买VS 2008或2010 Professional。获得2010年会有不利因素吗？

 

提前感谢您的帮助。 &NBSP;如果我在错误的论坛，我道歉。

解决方案

Tunesy，

我无法回答你的所有问题，但也许我可以指出你在其中几个方面的正确方向。

SQL与访问

去年我使用MS访问构建了一个计时系统。不幸的是，同时存在许多活动连接。在那个时候，用户还试图在同一时间吃午饭，并且系统崩溃了。因此，我不得不使用Visual Studio 2008重建它，并将数据库放在我们的SQL服务器上。从那时起，我们没有任何问题，因为有太多的活动连接或系统崩溃。所以回答这个问题的最好方法就是问，你是否希望很多用户同时积极地使用数据库。如果是，那么我会倾向于SQL数据库。如果只有一对（或者一个），那么Access应该没问题。我仍然完全在Access中为该部门创建较小的数据库。

在我的实验中，到目前为止，我在VS 2008中创建的程序并不慢。通过标准的网络连接，几乎所有用户都可以从关闭的计算机上启动，登录，打开时钟，并在2分钟内完成计时。

I还没有使用过VS 2010，所以我对此没有任何意见。

希望这对你的问题有所了解。

&NBSP;

<!-- @page { margin: 0.79in } P { margin-bottom: 0.08in } -->

Some noob questions here. I'm a fifty year old who hasn't done much programming in a long time. I'm building what I think would be termed a stand alone, local database, single user application using Visual Basic. My questions concern the database work involved, which I have very little experience with. This application will have a database bundled with it that will have possibly a hundred thousand records by the time I'm done. Each record will have up to 100 pieces of data. I will have most of the data in MS Access format. Most of the database queries will be quite basic. I'm about half way through my Visual Basic book (by Murach) and haven't gotten to the database stuff yet, but I'd like feedback from you guys. So far the VB stuff is pretty clear to me. I probably won't be coding any database stuff for a few months yet. My questions are:

 

Is Visual Basic by itself sufficient to handle that kind of data load, or will it be too slow? Will LINQ be helpful?

 

Should I use SQL Server for the database work, or Access, or . . . ?

 

I plan to buy either VS 2008 or 2010 Professional. Is there a downside to getting 2010?

 

Thanks in advance for any help.  My apologies if I'm in the wrong forum.

解决方案

Tunesy,

I can't answer all of your questions, but perhaps I can point you in the right direction on a couple of them.

SQL vs. Access

Last year I built a timekeeping system using MS access. Unfortunately there were to many active connections at the same time. At ne point 30+ user tried to clock out for lunch at the same time and the system crashed. So I had to rebuild it using Visual Studio 2008 and put the database on our SQL server. Since then we haven't had any issue with having too many active connections or the system crashing. So the best way to answer this is to ask, do you expect a lot of user to be actively using the database at the same time. If yes, then I would lean towards a SQL database. If there will be only a couple (or perhaps one), then Access should be fine. I still create smaller databases for the department entirely in Access.

In my experiance so far, the programs I have created in VS 2008 have not been slow. With a standard network connection nearly all of the users can go from a shut down computer, boot up, log in, open their time clock, and clock in within 2 minutes.

I haven't yet used VS 2010, so I can offer no opinion on that.

Hopefully this has shed a little light on your issues.

 

这篇关于Noob关于独立，单用户应用程序中的数据库工作的问题。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！