asp - web应用程序 - 数据库？ [英] asp - web application - DB ?

问题描述

我有一个基于asp的网络应用程序，目标是由

内网用户说10-500或更多。目前，我使用MS Access作为我的后端对我的

Web应用程序进行了原型设计。可以

如果我继续使用MS

在这种多连接情况下访问，有人可以证明我会遇到麻烦。其他数据库如Sybase

iAnywhere，MS Sql server Express版，MSDE将被考虑用于MS

访问更换。


如果我在某处获得比较列表会很好...


我们不想在SQL Server，Oracle等数据库上花费更多金额，

Sybase，我们也只有极少的专业知识，应该能够管理

数据库。


谢谢

I have an asp based web applicaiton and that is targeted to be used by
intranet users say 10-500 or may be more. Currently, I have prototyped my
Web application using MS Access as my backend. Can
somebody justify me that I will get in trouble if I continue to use MS
Access in this multi connection situation. What other databases like Sybase
iAnywhere, MS Sql server Express edition, MSDE to be considered for the MS
Access replacement.

It will be nice if I get the comparision list somewhere...

We dont want to spend more amount on databases like SQL Server, Oracle,
Sybase, also we have minimal expertise who should be able to manage the
databases.

Thanks

推荐答案

访问可以应对4个连续用户，考虑到通常需要一小时的时间才能从数据库发出请求，即堆，

第五个用户仍然可以得到他的请求，但他可能需要等待一小段

秒。


但我会这样做使用MSDE它是免费且强大的


" abcd" < AB ** @ abcd.com>在消息中写道

新闻：e6 **************** @ TK2MSFTNGP12.phx.gbl ...

Access can cope with 4 consecutive users, considering that it takes a
fraction of a second normally to make a request from the DB, that is heaps,
the 5th user would still get his request but he may have to wait a fraction
of a second.

But all the same I would use MSDE it s free and powerful

"abcd" <ab**@abcd.com> wrote in message
news:e6****************@TK2MSFTNGP12.phx.gbl...

我有一个基于asp的Web应用程序，目标是由内部网用户使用，例如10-500或更多。目前，我已经使用MS Access作为我的后端对我的
Web应用程序进行了原型设计。如果我在这种多连接情况下继续使用MS
Access，那么有人可以证明我会遇到麻烦。还有哪些其他数据库如Sybase iAnywhere，MS Sql server Express版，MSDE可以考虑更换MS Access。

如果我在某处获得比较列表会很好...

我们不想在SQL Server，Oracle，Sybase这样的数据库上投入更多资金，而且我们也应该能够管理数据库。

谢谢

I have an asp based web applicaiton and that is targeted to be used by
intranet users say 10-500 or may be more. Currently, I have prototyped my
Web application using MS Access as my backend. Can
somebody justify me that I will get in trouble if I continue to use MS
Access in this multi connection situation. What other databases like
Sybase iAnywhere, MS Sql server Express edition, MSDE to be considered for
the MS Access replacement.

It will be nice if I get the comparision list somewhere...

We dont want to spend more amount on databases like SQL Server, Oracle,
Sybase, also we have minimal expertise who should be able to manage the
databases.

Thanks

AlanM写道：

Access可以应付4个​​连续用户，


LOL

4？你在哪里得到这个号码？

尝试在Access新闻组中提出这个声明，看看你得到了什么回复。

:-)

考虑通常需要几分之一秒才能从DB发出请求，即第5位用户仍会得到他的请求，但他可能需要等待一小部分一秒钟。

但是我会使用MSDE它是免费且强大的


没有争论。编写一个使用后端Access访问许多用户的应用程序是很难的。可能，但很难。你必须正确地做所有事情

- 根本没有错误的余地。


MSDE的唯一问题是它可以用作开发

平台和threfore有内置限制来减慢响应时

太多并发线程正在运行（确切的数字启动

节流是激烈的辩论。我已经看到了5到10之间的声称。

有些因素会影响这个数字。）


更好答案是等待几周并获得SQL 2005 Express。这是免费的b $ b，没有限制限制。
abcd < AB ** @ abcd.com>在消息中写道
新闻：e6 **************** @ TK2MSFTNGP12.phx.gbl ...

Access can cope with 4 consecutive users,
LOL
4? Where did you get this number?
Try making this claim in an Access newsgroup and see what response you get.
:-)
considering that it takes a
fraction of a second normally to make a request from the DB, that is
heaps, the 5th user would still get his request but he may have to
wait a fraction of a second.

But all the same I would use MSDE it s free and powerful

No argument. It is HARD to write an application that handles that many users
using Access on the backend. Possible, but hard. You have to do everything
correctly - no room for error at all.

The only issue with MSDE is that it is intended to be used as a development
platform and threfore has built-in throttling to slow down the response when
too many concurrent threads are running (the exact number that initiates the
throttling is hotly debated. I''ve seen claims of anywhere from 5 to 10.
There are factors that can affect this number)

A better answer is to wait a couple weeks and get SQL 2005 Express. it''s
free, and has no throttling restriction.
"abcd" <ab**@abcd.com> wrote in message
news:e6****************@TK2MSFTNGP12.phx.gbl...

我有一个基于asp的网络应用程序目标是使用内网用户说10-500或者更多。目前，我已经使用MS Access作为我的后端来构建我的Web应用程序原型。如果我继续在这种多连接情况下使用MS Access，那么有人可以证明我会遇到麻烦。还有哪些其他数据库像Sybase iAnywhere，MS Sql server Express版，MSDE要考虑更换MS Access。

如果我在某处获得比较列表会很好...

我们不想在SQL Server，Oracle，Sybase这样的数据库上投入更多资金，我们也应该能够管理数据库。

谢谢

I have an asp based web applicaiton and that is targeted to be used
by intranet users say 10-500 or may be more. Currently, I have
prototyped my Web application using MS Access as my backend. Can
somebody justify me that I will get in trouble if I continue to use
MS Access in this multi connection situation. What other databases
like Sybase iAnywhere, MS Sql server Express edition, MSDE to be
considered for the MS Access replacement.

It will be nice if I get the comparision list somewhere...

We dont want to spend more amount on databases like SQL Server,
Oracle, Sybase, also we have minimal expertise who should be able to
manage the databases.

Thanks

-

Microsoft MVP - ASP / ASP.NET
请回复新闻组。这个电子邮件帐户是我的垃圾邮件陷阱所以我

不经常检查它。如果您必须离线回复，请删除

NO SPAM

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don''t check it very often. If you must reply off-line, then remove the
"NO SPAM"

>更好的答案是等待几周并获得SQL 2005 Express。这是

> A better answer is to wait a couple weeks and get SQL 2005 Express. it''s

免费，并且没有限制限制。

free, and has no throttling restriction.

你碰巧知道有多少并发（不连续;））连接

新的SQL Svr Express将允许？

Do you happen to know how many concurrent (not consecutive ;)) connections
the new SQL Svr Express will allow?

这篇关于asp - web应用程序 - 数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！