Compare Data

[Rob]

Hi All,

I have two large tables - > 14K in one and > 16K in the other. I am trying
to show only those records that match. When I link the two tables in the
query via the common field and tell it to show the data it takes over fifteen
minutes to show the data. I have even tried to show uniques and group to
make sure that I am not getting duplicates. No luck. I even went so far as
to add a matched yes/no field in the tables and run a form that would open
one table in a recordset and look for the data in the other recordset and
change the yes/no field to yes. This will work as well but it takes about 30
minutes to finish. I am using a Core 2 Duo 2.0 ghz system with 2 gb of
memory. Any suggestions would be appreciated.

Thanks,

Rob

 

[Dirk Goldgar]

Hi All,

I have two large tables - > 14K in one and > 16K in the other. I am
trying
to show only those records that match. When I link the two tables in the
query via the common field and tell it to show the data it takes over
fifteen
minutes to show the data. I have even tried to show uniques and group to
make sure that I am not getting duplicates. No luck. I even went so far
as
to add a matched yes/no field in the tables and run a form that would open
one table in a recordset and look for the data in the other recordset and
change the yes/no field to yes. This will work as well but it takes about
30
minutes to finish. I am using a Core 2 Duo 2.0 ghz system with 2 gb of
memory. Any suggestions would be appreciated.

I suspect that the field you're matching on is not indexed. If that's the
case, index it in both tables and try your query again.

Even unindexed, that seems a long processing time for the number of records
involved. Are these tables in a database that is local, on your PC, or is
it on a network share?

 

[Rob]

Dirk,

The data is local. I am also getting multiple duplicates which makes the
query results explode. The system is still trying to get to the end of the
recordset as I type.

 

[Rob]

Dirk,

It also continually says Accessing Records .... press Ctrl + Break to stop.
When I do press the keys nothing happens and the query says not responding.

 

[Dirk Goldgar]

Dirk,

The data is local. I am also getting multiple duplicates which makes the
query results explode. The system is still trying to get to the end of
the
recordset as I type.

Could you post the SQL of your query?