Data Table Index

RE: Data Table Index

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:
[color=blue]
> 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
>[/color]