Asp.net缓存与Access缓存。 [英] Asp.net caching vs Access Caching.

问题描述

嗨伙计们。

我学习asp.net并将其与传统的asp进行比较和

访问开发。


问题是这个：

1 /我有这个Acceess女士adp项目应用程序在我的

Ms Sql服务器数据库上工作正常。

在我的主表单中，我有一个带有客户名称的Access-combobox来自我的

客户表。

在这个组合框中大约有2000条记录。

使用这个组合框，用户可以进行数据库查询，只能在我的主表中与他们选择的客户相关的记录中使用
。

在这种情况下，comboxbox加载速度非常快。


2 /然后我将sql server数据库移动到远程服务器。

然后我通过互联网连接我的Client Access2000-adp文件。

现在带有客户名称的组合框加载速度更慢，但只有当我加载Access时才会加载
主要形式。

然后看来组合框以某种方式缓存，因为那时

用户可以快速，方便地查找客户记录。

此approch对我的用户来说还可以。


3 /现在我用asp.net-webform尝试相同的方法。

我为asp.net下拉列表中的datsource。但即便如此，在这个

的情况下，客户asp：下拉加载在我发布的每一个回发上都很慢。

我想现在我的用户习惯了我的用户友好访问形式wouln 't

就像从Access应用程序中移动一样。进入一个asp.net应用程序。


考虑是否有可能使用缓存组合框和

下载到客户端的方式Access-projekt-asp-表格可以用

Visual studio dot net。

有谁知道这些问题吗？

BigOlle

Hi folks.
I learning asp.net and compare it with traditional asp and
Access-developing.

The issue is this one:
1/I have this Ms Acceess adp-project application that works fine on my
Ms Sql server database.
In my main form I have an Access-combobox with Customer-names from my
customer table.
In this combo-box are about 2000 records.
With this combobox the users can make a database query to work on only
the records in
my main table that are related to the customer they have chosen.
In this situation the comboxbox load very quickly.

2/ Then I moved the sql server databases to a remote server.
Then I connect though my Client Access2000-adp file through internet.
Now the combobox with customer names loads more slowly, but only then
first time when I load the Access main-form.
Then it seems that the combobox is cached somehow because then the
users can look for customer-records fast and convient.
Also this approch is OK for my users.

3/ And now I try the same approach with an asp.net-webform.
I cach the datsource for the asp.net dropdown. But even so, in this
case the customers asp:dropdown loads slowly on every postback I make.
I think now that my users used to my userfriendly Access-forms wouln''t
like the move from the Access app. into an asp.net app.

Thinking about if there is a possibilty to cach comboboxes and
dropdowns on the client the way Access-projekt-asp-forms can do with
Visual studio dot net.
Does anyone know about these issues?
BigOlle

推荐答案

ol**@ylm.se 写道：

嗨伙计们。
我学习asp.net并将其与传统的asp进行比较和
访问开发。

问题是这个：
1 /我有这个Acceess女士adp项目应用程序在我的Sql服务器数据库数据库上工作正常。
在我的主表单中，我有一个Access-combobox，其中包含来自我的
客户表的客户名称。
在这个组合框中大约有2000条记录。
使用这个组合框，用户可以进行数据库查询，只处理我主表中与之相关的记录。他们选择的客户。
在这种情况下comboxbox加载速度很快。

2 /然后我将sql server数据库移动到远程服务器。
然后我通过Internet连接我的Client Access2000-adp文件。
现在带有客户名称的组合框加载速度更慢，但只有在我加载Access主窗体时才第一次使用。
然后似乎组合框以某种方式缓存，因为那时
用户可以快速，方便地查找客户记录。
此approch也适合我的用户。

3 /现在我尝试使用asp.net-webform进行同样的方法。 />我为asp.net下拉列表中的datsource。但即便如此，在这种情况下，客户asp：下拉加载在我发布的每一个回发上都很慢。
我认为现在我的用户习惯了我的用户友好访问表格了不会喜欢从Access应用程序迁移。进入一个asp.net应用程序。

考虑是否有可能通过Access-projekt-asp-forms可以用来实现组合框和
下拉客户端
Visual Studio dot net。
有没有人知道这些问题？
BigOlle

Hi folks.
I learning asp.net and compare it with traditional asp and
Access-developing.

The issue is this one:
1/I have this Ms Acceess adp-project application that works fine on my
Ms Sql server database.
In my main form I have an Access-combobox with Customer-names from my
customer table.
In this combo-box are about 2000 records.
With this combobox the users can make a database query to work on only
the records in
my main table that are related to the customer they have chosen.
In this situation the comboxbox load very quickly.

2/ Then I moved the sql server databases to a remote server.
Then I connect though my Client Access2000-adp file through internet.
Now the combobox with customer names loads more slowly, but only then
first time when I load the Access main-form.
Then it seems that the combobox is cached somehow because then the
users can look for customer-records fast and convient.
Also this approch is OK for my users.

3/ And now I try the same approach with an asp.net-webform.
I cach the datsource for the asp.net dropdown. But even so, in this
case the customers asp:dropdown loads slowly on every postback I make.
I think now that my users used to my userfriendly Access-forms wouln''t
like the move from the Access app. into an asp.net app.

Thinking about if there is a possibilty to cach comboboxes and
dropdowns on the client the way Access-projekt-asp-forms can do with
Visual studio dot net.
Does anyone know about these issues?
BigOlle

我也是一个学习ASP.NET的Access人员

我建议你买一本书：Microsoft asp.net web matrix入门套件。

我买它是免费的Microsoft开发环境的信息

Web Matrix（Visual Studio .NET的Lite版本）。它还有关于缓存记录的良好信息，以解决您遇到的问题。


我的副本是关于

I am also an Access person who is learning ASP.NET
I recommend you get a book: "Microsoft asp.net web matrix starter kit".
I bought it for the info on the FREE Microsoft development environment
Web Matrix (a sort of Lite version of Visual studio . NET). IT also has
good info on caching records read to solve just the kind of issue you have.

I got my copy for about

8包括通过亚马逊运送，从他们的第三方供应商的b
。


Bob

8 including shipping through Amazon, from one
of their 3rd party vendors.

Bob

感谢您的提示。

我可以通过这本书，如果你认为它是有用的，即使我是

安装Visual Studio dot net webb矩阵。


a问题：因为我打算在我的电脑上安装visual studio dot net我想知道Webb Mattrix是否可以安装在同一台计算机上。


但我仍然不介意在这个问题上获得更多的代码提示

在客户端上缓存asp.net下拉菜单

thanks for your tip.
I problably by this book, if you think that it is userful even if I am
installing Visual Studio dot net instead of webb Matrix.

a question: As I plan to install visual studio dot net on my computer i
wonder if Webb Mattrix can be installed on the same computer.

But I still don''t mind getting some more code tip on this issue on
caching asp.net dropdowns on the client

这篇关于Asp.net缓存与Access缓存。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！