Data Table Index

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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...
 
Back
Top