On 11/12/00, W Luke penned:
>Excellent. I basically have 2 queries that both return large amounts of
>records - the first being as you describe above - however the second is an
>interesting dilema. I have a table called Locations, with "County" and
>"Town." Using the cool TwoSelectsRelated tag, I'm populating both boxes
>(users choose a county - and then a town). However with a current town list
>of over 1600, and due to the fact that TwoSelectsRelated loads both columns
>of the table in their entirity, this takes *ages* to download. Using
>TwoSelectsRelated is by far the nicest option available - but unfortunately
>I might have to change.
>
>Hopefully caching the query will speed things up a little anyhow.
I tried using it in my shopping cart also for countries and
states/territories. It was dreadfully slow, because of the huge
amount of javascript code that had to be loaded, and didn't work at
times probably due to the same thing. I ended up just going to an
extra screen to choose the state based on the country. An extra
click, but still much quicker.
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
