Data Table Index

30 May 2006 2:33 PM

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

1 Jun 2006 3:06 AM

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

Show quoteHide quote

"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
>