本地表或链接的本地数据库？ [英] Local tables or linked local database?
问题描述
我有一个拆分前端/后端系统。但是我创建了一些
本地表来执行某些操作。有一种趋势，即前端臃肿，所以我已经设置''紧凑'''
我认为我已经读过一些线程（虽然我现在找不到它们，但是其他人将这些表放在本地的链接数据库中）。我可以做到这一点，但我很想知道它有什么优势。
和缺点，如果有的话。
任何关于本地表与本地
数据库的相对优点的观察将是受欢迎的
Jim
我认为优点是你不需要紧凑的紧凑，而且你想要扔掉的临时垃圾数据真的是你的b $ b更好的放置其他
在哪里。
这里的想法是分裂系统意味着你的mde是您分发的
可执行文件。它包含代码。据推测，你可以发布一个更新，但是这些临时文件不会被覆盖。
Tony的网站上有一些示例代码可以覆盖创建一个临时mdb文件，
所以，显然我们中的一些人确实查看了创建临时mdb
文件和优势的额外工作。 （而且，你可以简单地删除文件而不用担心
膨胀后）。
我不觉得它是巨大的交易，也不是一个硬广告快速规则，但我会作为一个
规则使用临时外部mdb文件来处理那种工作类型的东西。
-
Albert D. Kallal（访问MVP）
加拿大艾伯塔省埃德蒙顿
pl ***************** @ msn.com
访问当它运行任何操作时，它会减轻它在表格中来回传递的数据量的悲惨工作。你可以使用数据库中的本地表来获得更好的性能
本身。关于紧凑关闭的唯一问题是
一个Windows权限 - 例如，如果你在数据库文件上设置了特殊的
权限，那将是继续使用
压缩版本。
Jim Devenish写道：
我有分裂前端/后端系统。但是我创建了一些
本地表来执行某些操作。有一种趋势，即前端臃肿，所以我已经设置''紧凑'''
我认为我已经读过一些线程（虽然我现在找不到它们，但是其他人将这些表放在本地的链接数据库中）。我可以做到这一点，但我很想知道它有什么优势。
和缺点，如果有的话。
任何关于本地表与本地
数据库的相对优点的观察将是受欢迎的
Jim
" Pachydermitis" < pr ******* @ gmail.comwrote在
新闻：11 ********************* @ i3g2000cwc。 googlegrou ps.com：
Access做了一项悲惨的工作，可以减少它在桌子上来回传递的数据量。运行任何操作。
在数据库本身中使用本地表
你可能会获得更好的性能。
Hogwash。从链接的
表中抽取数据非常有效。
-
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com < a rel =nofollowhref =http://www.dfenton.com/DFA/target =_ blank> http://www.dfenton.com/DFA/
I have a split front end/back end system. However I create a number of
local tables to carry out certain operations. There is a tendency for
the front end to bloat so I have set ''compact on close''
I think that I have read in some threads (althoug I cannot find them
now) that others place such tables in a local, linked database. I
could do this but I am interested to know what would be the advantages.
And disadvantages, if any.
Any observations on the relative merits of local tables vs a local
database would be welcome
Jim
I think the advantages are that you don''t need the compact on close, and
really, temp junk data that you plan to throw out is better placed else
where.
The idea here is that a split system means that your "mde" is your
executable file that you distribute. It contains code. Presumably, you could
issue a update, and those temp files would NOT be overwritten.
There is some sample code at Tony''s site that does create a temp mdb file,
so, obviously some of us do view the extra effort of creating a temp mdb
file and advantage. (and, you can simply delete the file and not worry about
bloat after you done so).
I don''t think it is a huge deal, nor a hard ad fast rule, but I would as a
rule use a temp external mdb file for that working type stuff.
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
Access does a miserable job of mitigating the amount of data that it
passes back and forth to tables when it runs any operation. You will
probably get better performance having the local tables in the database
itself. The only issue that I have ever had with compact on close is
one of windows permissions - for example if you have special
permissions set on the database file, those will be gone on the
compacted version.
Jim Devenish wrote:I have a split front end/back end system. However I create a number of
local tables to carry out certain operations. There is a tendency for
the front end to bloat so I have set ''compact on close''
I think that I have read in some threads (althoug I cannot find them
now) that others place such tables in a local, linked database. I
could do this but I am interested to know what would be the advantages.
And disadvantages, if any.
Any observations on the relative merits of local tables vs a local
database would be welcome
Jim
"Pachydermitis" <pr*******@gmail.comwrote in
news:11*********************@i3g2000cwc.googlegrou ps.com:
Access does a miserable job of mitigating the amount of data that
it passes back and forth to tables when it runs any operation.
You will probably get better performance having the local tables
in the database itself.Hogwash. Access is extremely efficient in drawing data from linked
tables.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
这篇关于本地表或链接的本地数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
