Data Table Index

[Chris]

I have a remote database with two table A & B. A contains 100 or so
columns and anywhere from 21-50k records. B has 5 columns and anywhere
from 100-200k records. B has a many to one relationship with A. I need
to process all of these records one by one. What I'm doing right now is
pulling down all of table A and then as I process each record doing
another call to pull down the many records out of B.

What I'd like to do is pull down all the records of A & B locally and
then do a local select on table B for each record in A. I can't find a
way to index the local table to make the lookup fast. Any thoughts on
the best way to do this?

Chris

[ewok66]

Did you create a relationship between the two tables? When you do that, one
a row, you can call the 'getchildren' method, which will get all the child
rows for that one row. Not sure how effecient that will be on that many rows
though...
--
--ewok
MCSA+M,MCSE, MCSD, MCDBA,MCITP
"Chris" wrote:

I have a remote database with two table A & B. A contains 100 or so
columns and anywhere from 21-50k records. B has 5 columns and anywhere
from 100-200k records. B has a many to one relationship with A. I need
to process all of these records one by one. What I'm doing right now is
pulling down all of table A and then as I process each record doing
another call to pull down the many records out of B.

What I'd like to do is pull down all the records of A & B locally and
then do a local select on table B for each record in A. I can't find a
way to index the local table to make the lookup fast. Any thoughts on
the best way to do this?

Chris