访问和SQL Server速度比较 [英] Access and SQL Server Speed Comparison
问题描述
我有一张包含8百万条记录的表格。需要解析和修改
所需的一些字段。例如，ABC DEF将解析为两个
字段ABC和DEF。如果有123，在现场，如果将
替换为456。例如，XYZ 123 AAA和XYZ 123 AAA。将是XYZ 456
AAA。此外，更新查询和追加查询将在
项目中使用。
提供上述信息，这将是一个更快的数据库来做这个/>
- MS-Access 2003或SQL Server 2000？
SQL Learner写道：
< blockquote class =post_quotes>
我有一张包含8百万条记录的表格。需要解析和修改
所需的一些字段。例如，ABC DEF将解析为两个
字段ABC和DEF。如果有123，在现场，如果将
替换为456。例如，XYZ 123 AAA和XYZ 123 AAA。将是XYZ 456
AAA。此外，更新查询和追加查询将在
项目中使用。
提供上述信息，这将是一个更快的数据库来做这个/>
- MS-Access 2003或SQL Server 2000？
请注意，Access前端可以连接到Jet或SQL
后端。 （前者导致一个自包含的.MDB文件。）
注意过早优化。这些变化多久发生一次？
？一年一次，一个月，一天，一小时？如果它不常见，那么加速它们的价格可能不如优化其他因素重要，
，例如易于使用，易于开发，内存占用少。
嗨Ed，
感谢您的回复。我只需要知道哪一个更快
，因为用于此项目的查询可能很多。如果两者都是相同的，那么我将只使用Access。这只是一次性事件，
但更新查询可能很慢。我提供的示例仅为演示目的简化了
。让我们假设，我需要在8百万记录表上运行这样的查询10次。给我一个
2GB Rem，具有非常快的硬盘和快速到期CPU，SQL Server
会更快吗？如果是，请花多少钱？
- 草蜢 -
" SQL learner" < ex *********** @ gmail.comwrote in message
news：11 ******************* **@s48g2000cws.googlegro ups.com ...
我有一张包含8百万条记录的表格。需要解析和修改
所需的一些字段。例如，ABC DEF将解析为两个
字段ABC和DEF。如果有123，在现场，如果将
替换为456。例如，XYZ 123 AAA和XYZ 123 AAA。将是XYZ 456
AAA。此外，更新查询和追加查询将在
项目中使用。
提供上述信息，这将是一个更快的数据库来做这个/>
- MS-Access 2003或SQL Server 2000？
在相同的硬件上，SQL Server 2000将更快地运行查询。根据您的技能，在SQL Server 2000上编写查询可能需要更长的时间，而不是在Access中编写和运行所需的
...
Hi,
I have a table with 8 millions records. Some of the fields needed to
be parse and modified. Example, "ABC DEF" will be parsed into two
fields "ABC" and "DEF". And If there is "123" in the field, if will
be replaced by "456". For example, "XYZ 123 AAA" will be "XYZ 456
AAA". Also, update query and append query will be used in the
project.
Give the above information, what will be a faster database to do this
- MS-Access 2003 or SQL Server 2000?
SQL Learner wrote:
I have a table with 8 millions records. Some of the fields needed to
be parse and modified. Example, "ABC DEF" will be parsed into two
fields "ABC" and "DEF". And If there is "123" in the field, if will
be replaced by "456". For example, "XYZ 123 AAA" will be "XYZ 456
AAA". Also, update query and append query will be used in the
project.
Give the above information, what will be a faster database to do this
- MS-Access 2003 or SQL Server 2000?Note that an Access front-end can be connected to either a Jet or SQL
back-end. (The former leads to a self-contained .MDB file.)
Beware of premature optimization. How often do these sorts of changes
occur? Once a year, month, day, hour? If it''s infrequent, then
speeding them up may be less important than optimizing other factors,
e.g. ease of use, ease of development, low memory footprint.
Hi Ed,
Thank you for your reply. I just need to know which one is faster
since the queries that used for this project can be many. If both are
the same, then I will just use Access. This is just a one time event,
but the update queries can be slow. The example that I provided was
simplified for demostration purpose only. Let''s assume, I need to run
the such query on a 8 millions records table 10 times. Give I have a
2GB Rem, with very fast hard disk and fast Due CPU, Would SQL Server
be faster? If yes, by how much?
- Grasshopper -
"SQL Learner" <ex***********@gmail.comwrote in message
news:11*********************@s48g2000cws.googlegro ups.com...Hi,
I have a table with 8 millions records. Some of the fields needed to
be parse and modified. Example, "ABC DEF" will be parsed into two
fields "ABC" and "DEF". And If there is "123" in the field, if will
be replaced by "456". For example, "XYZ 123 AAA" will be "XYZ 456
AAA". Also, update query and append query will be used in the
project.
Give the above information, what will be a faster database to do this
- MS-Access 2003 or SQL Server 2000?
On equal hardware SQL Server 2000 will run the query faster. Depending on
your skills it may take longer to write the queries on SQL Server 2000 than
it takes to write and run in Access...
这篇关于访问和SQL Server速度比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
