交叉：访问速度 [英] Cross: Access speed
问题描述
我可以使用大数据库的访问权限（cca 10-30 MB，在
数据库中使用cca 10-30k行）。它将是asp.net 2.0 aplication和非常快的服务器。主要是简单的交易（比如SELECT * From Books Where Name，比如''SomeName％''）。
如果我有10 000个独特的话可能会有问题吗？每天都有访客？我看到很多
大站点都有访问数据库。没关系，风险很大吗？
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like ''SomeName%'').
Can it be problem if I have 10 000 unique visitors per day? I see that many
big sites have access database. Is it ok, ir it is big risk?
推荐答案
Igor写道：
Igor wrote:
我可以使用大数据库访问（cca 10-30 MB，cca 10-30k行在
数据库中）。它将是asp.net 2.0 aplication和非常快的服务器。主要是简单的交易（比如SELECT * From Books Where Name，比如''SomeName％''）。
如果我有10 000个独特的话可能会有问题吗？每天都有访客？我看到很多
大站点都有访问数据库。没关系，它有很大的风险吗？
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like ''SomeName%'').
Can it be problem if I have 10 000 unique visitors per day? I see that many
big sites have access database. Is it ok, ir it is big risk?
假设：
- 您在Name列上有索引
- MDB在本地磁盘上
- 磁盘没有被其他东西大量使用
- 唯一身份访问者只进行一次查询（或只有少数几次）
- 负载是合理的好分布随着时间的推移
那么它应该不是问题。
30 MB可以很容易地缓存在磁盘/文件缓存中。
10000 /天只需7小时/ 24小时或21 /分钟
8小时且不重。
Arne
Assuming that:
- you have index on Name column
- the MDB is on a local disk
- the disk is not heavily used by something else
- the unique visitors only make one query (or only a few)
- the load is reasonable good distributed over time
then it should not be a problem.
30 MB can easily be cached in disk/file cache.
10000/day is only 7/minute over 24 hours or 21/minute over
8 hours and that is not heavy.
Arne
您可能想要缓存经常运行的项目（但很少更改）
查询。
System.Web命名空间中有一个Cache对象。
您还可以找到一个名为WeakReference的对象。这是一种缓存
项目的方法，但如果有内存消耗则释放它们。
我不会从Access开始。我会从MSDE（2000）或Sql Express开始
（2005）。
但是你可以把它拉下来。
" Igor" < ig ** @ nesalji.hrwrote in message
news：em ********** @ sunce.iskon.hr ...
You might want to cache items that are very often run (but seldom change)
queries.
There is a Cache object in the System.Web namespace.
You can also find an object called "WeakReference" which is a way to cache
items, but to release them if there is a memory drain.
I wouldn''t start with Access. I''d start with MSDE (2000) or Sql Express
(2005).
But you might be able to pull it off.
"Igor" <ig**@nesalji.hrwrote in message
news:em**********@sunce.iskon.hr...
我可以使用大数据库的访问权限（在
数据库中cca 10-30 MB，cca 10-30k行）。它将是asp.net 2.0 aplication和非常快的服务器。通常是简单的交易（比如SELECT * From Books Where Name，比如
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like
''TomeName％''）。
''SomeName%'').
>
如果我每天有10 000个唯一身份访问者，那会有问题吗？我看到
>
Can it be problem if I have 10 000 unique visitors per day? I see that
很多
many
大型网站都有访问数据库。没关系，风险很大吗？
big sites have access database. Is it ok, ir it is big risk?
Igor，
它与其他人写的相同，但可能更容易管理。
您可以设置程序中共享的数据集。因为所有用户共享
，所有用户的应用程序都是相同的。它必须是一个数据集，来自用户的
永远不会被更改，否则你永远不应该在AspNet应用程序中创建一个
共享数据集。
别忘了制作一个额外的页面来将数据集设置为空，否则
你永远无法改变它。
Cor
" Igor" < ig ** @ berst的nesalji.hrschreef
news：em ********** @ sunce.iskon.hr ...
Igor,
It is the same as the others wrote, however probably easier to manage.
You can set a dataset shared in your program. Because all your users share
the same application is that for all your users. It has to be a dataset that
from the userside will never be changed otherwise you should never create a
shared dataset in an AspNet appliction.
Don''t forget to make an extra page to set the dataset to nothing, otherwise
you can never change it.
Cor
"Igor" <ig**@nesalji.hrschreef in bericht
news:em**********@sunce.iskon.hr...
我可以使用大数据库的访问权限（在
数据库中cca 10-30 MB，cca 10-30k行）。它将是asp.net 2.0 aplication和非常快的服务器。主要是
简单的交易（比如SELECT * From Books Where Name like
''TomeName％''）。
可以吗如果我每天有10 000名独立访问者，那会有问题吗？我看到
许多大型网站都有访问数据库。没关系，风险很大吗？
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like
''SomeName%'').
Can it be problem if I have 10 000 unique visitors per day? I see that
many big sites have access database. Is it ok, ir it is big risk?
这篇关于交叉：访问速度的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
