Does appending records skip indexes and constraints?

M

MasAccess

I want to compare the processing time for appending a record and inserting a
record, Which is faster.
I think if appending a record skips the index and db constraints then it
will be faster than inserting.

Thank you all
 
A

Arvin Meyer [MVP]

MasAccess said:
I want to compare the processing time for appending a record and inserting a
record, Which is faster.
I think if appending a record skips the index and db constraints then it
will be faster than inserting.
Click to expand...

Appending and inserting (assuming you are talking about queries and coded
recordsets) both respect indexes. For large datasets, it is sometimes useful
to drop the indexes, do the append, and rebuild the indexes. Queries, btw,
are generally faster than adding new records via recordsets.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top