后端数据库性能 [英] Backend Database Performance
问题描述
大家好，
我有两个后端数据库，区域链接到前端数据库
，其中输入，检索和删除信息。从前端数据库访问的信息
来自两个数据库。
两个后端数据库每个至少225MB，因此访问
数据很慢并且运行查询很慢且令人沮丧，这导致数据库有时会崩溃。一开始我虽然是一个
网络连接，所以我将数据库复制到C盘来测试
连接，它是一样的，非常慢。 />
我试图运行性能分析器，改进组合框，
报告，查询，微软建议的子报告
http://office.microsoft.com/帮助... CH062526191033
但仍然访问数据很慢。
我的想法是删除大量记录，因为用户几乎不使用
这些记录，没有查询我可以用来删除一些
记录，例如删除产品ID 0到产品ID
10000.
有没有人知道我该怎么做，但删除两个后端数据库中的记录
，我试过这个但是de在/ b
中记录某些表格，但不是在所有表格中。我试图通过使用外键来确保
记录被删除但是它无效。
任何人都可以提供我如何做到这一点的想法或提高访问信息的
性能？
如果我删除一个大数字来自两个后端数据库的记录，
会更好地访问数据吗？
谢谢
Hi All,
I have two backend databases that area link to a frontend database
where information is entered, retrieved and deleted. The information
accessed from the frontend database is coming from both databases.
Both backend databases are at least 225MB each, therefore accessing
data is slow and running queries are slow and frustrating, this causes
the databases to crash at times. At the beginning I though it was a
network connection, so I copied the databases to C drive to test the
connection, it was the same, very slow.
I have tried to run performance analyser, improvement for combo boxes,
reports, queries, sub reports as suggested by Microsoft at
http://office.microsoft.com/assistan...CH062526191033
but still accessing the data is slow.
My idea is to delete a large number records since users hardly used
these records, there is no query that I can use to delete a number of
records for example to delete between Product ID 0 to Product ID
10000.
Does anyone have an idea how can I do this, but deleting the records
in both backend databases, I have tried this but delete the records in
certain tables only not in all tables. I have tried to make
relationship between tables by having foreign keys to make sure the
records are deleted but it is not working.
Can anyone provide an idea of how can I do this or to improve the
performance of accessing the information?
If I delete a large number of records from both backend databases,
would it make better to access data?
Thanks
推荐答案
区域链接是什么意思？我的前端有一个链接到每个表
在我的后端，这很好。区域链接是另一种类型
的链接？如果是这样，你可能想尝试将每个表链接到
前端。
当我需要删除记录时，我使用查询进行查询后端，
不是前端，查询表我要删除记录
。也许你可以试试，而不是试图使用链接和
级联删除。如果您确实想要从
一次删除多个表格，请确保Cascade Deletions在
表之间的连接属性中启用（转到关系窗口）。
但我认为不是删除记录而是可以将它们移入a
不同的数据库（存档）所以如果你以后确实需要它们，那么
可以访问它们。你可以使用make-table查询然后
将新表转移到一个新的.mdb文件中，然后从当前表中删除
记录。 />
jn**********@yahoo.com （ John）在留言新闻中写道：< b5 ************************** @ posting.google。 com> ...
What do you mean by area link? My front-end has a link to each table
in my back-end, and that works fine. Is an area link a different kind
of link? If so, you may want to try linking each table to the
front-end.
When I need to delete records I do it with a query in the back-end,
not the front-end, and query the table I''m going to delete the records
from. Maybe you could try that, instead of trying to use links and
cascade delete. If you do want to delete from more than one table at
a time, make sure "Cascade Deletions" in the join properties between
tables is enabled(go to the relationships window for this).
But I think instead of deleting records you could move them into a
different database (archive) so if you did need them in the future you
could access them. You could use make-table queries for this and then
transfer the new tables into a new .mdb file, and then delete the
records from your current tables.
jn**********@yahoo.com (John) wrote in message news:<b5**************************@posting.google. com>...
大家好，
我有两个后端数据库，区域链接到前端数据库
，输入，检索和删除信息。从前端数据库访问的信息来自两个数据库。
两个后端数据库每个至少225MB，因此访问数据很慢并且运行查询很慢且令人沮丧，这会导致数据库有时崩溃。一开始我虽然是网络连接，所以我把数据库复制到C盘来测试
连接，它是一样的，非常慢。
我有尝试运行性能分析器，改进组合框，报告，查询，子报告，如Microsoft建议的那样 http://office.microsoft.com/assistan...CH062526191033
但仍在访问数据很慢。
我的想法是删除大量的记录，因为用户几乎没用过这些记录，没有查询我可以用来删除一些
记录，例如删除产品ID 0到产品ID
10000.
有没有人知道我该怎么做，但删除后端数据库中的记录
，我试过这个，但删除了某些表中的记录，但不是全部ABLES。我试图通过使用外键来确保
记录被删除但它不起作用来建立表之间的关系。
任何人都可以提供我怎样的想法这样做还是为了提高访问信息的性能？
如果从后端数据库中删除大量记录，
会更好地访问数据吗？ br />
谢谢
Hi All,
I have two backend databases that area link to a frontend database
where information is entered, retrieved and deleted. The information
accessed from the frontend database is coming from both databases.
Both backend databases are at least 225MB each, therefore accessing
data is slow and running queries are slow and frustrating, this causes
the databases to crash at times. At the beginning I though it was a
network connection, so I copied the databases to C drive to test the
connection, it was the same, very slow.
I have tried to run performance analyser, improvement for combo boxes,
reports, queries, sub reports as suggested by Microsoft at
http://office.microsoft.com/assistan...CH062526191033
but still accessing the data is slow.
My idea is to delete a large number records since users hardly used
these records, there is no query that I can use to delete a number of
records for example to delete between Product ID 0 to Product ID
10000.
Does anyone have an idea how can I do this, but deleting the records
in both backend databases, I have tried this but delete the records in
certain tables only not in all tables. I have tried to make
relationship between tables by having foreign keys to make sure the
records are deleted but it is not working.
Can anyone provide an idea of how can I do this or to improve the
performance of accessing the information?
If I delete a large number of records from both backend databases,
would it make better to access data?
Thanks
" Julia Baresch" < JB ****** @ oldrepublic.com>在消息中写道
新闻：50 ************************** @ posting.google.c om ...
"Julia Baresch" <jb******@oldrepublic.com> wrote in message
news:50**************************@posting.google.c om...
区域链接是什么意思？我的前端在我的后端有一个指向每张桌子的链接，并且工作正常。区域链接是不同类型的链接？如果是这样，你可能想尝试将每个表链接到
前端。
当我需要删除记录时，我在后端使用查询来执行此操作，
不是前端，查询表我将删除记录
。 [snip]
What do you mean by area link? My front-end has a link to each table
in my back-end, and that works fine. Is an area link a different kind
of link? If so, you may want to try linking each table to the
front-end.
When I need to delete records I do it with a query in the back-end,
not the front-end, and query the table I''m going to delete the records
from. [snip]
在使用Jet后端的Access中，所有查询处理都是本地的。有
将查询存储在后端没有任何好处，因为Access只会在执行它之前通过网络拖动查询定义并且
当它执行时它将完全相同，如果查询是
存储在前端。
-
我没有查看此邮件附带的电子邮件帐户
。发送给... ...
在Hunter dot com的RBrandt
In Access when using a Jet back end ALL query processing is local. There
is no advantage to storing the query in the back end as Access will just
have to drag the query definition over the network before executing it and
when it does execute it will be exactly the same as if the query were
stored in the front end.
--
I don''t check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
jn ********** @ yahoo.com （约翰）写道：
jn**********@yahoo.com (John) wrote:
我有区域链接到前端数据库的两个后端数据库
输入，检索和删除信息的区域。从前端数据库访问的信息来自两个数据库。
两个后端数据库每个至少225MB，因此访问数据很慢并且运行查询很慢且令人沮丧，这会导致数据库有时崩溃。一开始我虽然是网络连接，所以我把数据库复制到C盘来测试
连接，它是一样的，非常慢。
Access 2000中最常见的三个性能问题是：
- LDB锁定持久记录集连接或始终打开绑定表单
更正（多个用户）
- 子数据表名称属性设置为[自动]应该是[无]
- 曲目名称自动更正应该关闭
有关这些，不太可能的原因，其他提示和MS KB链接的更多信息
文章访问我的访问性能常见问题页面
http://www.granite.ab.ca/access/performancefaq.htm
任何人都可以知道我该怎么做或提高访问信息的性能？
I have two backend databases that area link to a frontend database
where information is entered, retrieved and deleted. The information
accessed from the frontend database is coming from both databases.
Both backend databases are at least 225MB each, therefore accessing
data is slow and running queries are slow and frustrating, this causes
the databases to crash at times. At the beginning I though it was a
network connection, so I copied the databases to C drive to test the
connection, it was the same, very slow.
The three most common performance problems in Access 2000 are:
- LDB locking which a persistent recordset connection or an always open bound form
corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off
For more information on these, less likely causes, other tips and links to MS KB
articles visit my Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm
Can anyone provide an idea of how can I do this or to improve the
performance of accessing the information?
试试以上是第一个。如果你的表格被正确编入索引，那么你应该拥有10,000或500,000条记录并不重要。
Tony
-
Tony Toews，Microsoft Access MVP
请仅在新闻组中回复，以便其他人可以
阅读整个消息主题。
Microsoft Access Links，Hints，Tips&会计系统
http://www.granite.ab.ca /accsmstr.htm
这篇关于后端数据库性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
