Posted by Ed Murphy on 03/02/07 02:09

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.

[Back to original message]