Access and SQL Server Speed Comparison

#1

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?

#2

"SQL Learner" <excelmodeling (AT) gmail (DOT) com> wrote

Quote:

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?

perl

--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access and SQL Server Speed Comparison

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Access and SQL Server Speed Comparison - 03-01-2007 , 05:23 PM

Re: Access and SQL Server Speed Comparison - 03-01-2007 , 07:31 PM