I have a C++ application that I am ****ting - switching from using SQL
Server
as the
back end to using a local Access 2007 database. The API is ODBC. I was
able
to do
with without too much trouble, except for a serious performance problem.
This
application bascially dumps a whole lot of external data into the
database,
creating
records in a single parent table, with that table having multiple records
in
two
child tables. This app works just fine with SQL Server. With Access
however, after
putting in about 60 entries or so, it just slows to a crawl. I am seeing
a
delay of
2 or 3 seconds on every SQLExec call that does an INSERT. Any ideas?
Maybe
a problem with primary key values? The two child tables are using
autonumber variables as the key, and the key for the parent record is a
character string (the same) with an
incrementing number appended.
