> Thanks Heath for replying, I did get the TwoSelectedRelated working and
it
> works good. I just takes my page longer to load because the entire 3100+
> records have to be extracted from the database rather than just the ones
> related to the state.
I've found that the rendering times of large pages varies widely depending
on the speed of the computer the browser is running on, for example one page
that takes 15 seconds on a PII233 loads in under 2 seconds on a PIII 800.
Not sure why, but this difference really surprised me. What I'm getting at
is that the big slowdown in speed you're seeing may not be a difference in
backend database operations, just the page being rendered.
Also, I assume we're talking about an application being developed for a
highspeed network. Adding that much data and bloating the page size for an
app that might run over phone modems just doesn't make sense when all you're
doing is creating a nifty interface for the user to make a single selection.
In the end, it might be perceived as faster if you simply have the user make
the second selection on a subsequent page.
Jim
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
