[cfaussie] Re: How to speed up a Related Select Query?

Mon, 17 Apr 2006 16:20:25 -0700

Two options.

1. dont use that tag and write you own. Its using a JS Array that its caching on the client to do the related load. This is allways going to make the page load slower. as its loading up n*m number of records each time the page loads.

The alternative is to use AJAX or an IFrame to return the related query data.
http://www.indiankey.com/cfajax/examples/list.htm

2. Add an ID index if it doesnt already have one to your table.

hth

Pat


On 4/17/06, Jonas H <[EMAIL PROTECTED]> wrote:

Hi,

I have been working on a related select i.e. 2 dropdowns where the
second one is depended of the first one.
I have been using this customtag http://tutorial218.easycfm.com/ and it
is all working OK.

I am using the related select when choosing locality and postcode. I
have used the csv file that you can download from Australia posts
website and imported it to my MySQL database. The problem I have is
that it is REALLY slow. I am using cachedWithin in the query but it
doesn't seem to help much. Anyone have any ideas how to speed it up.

Thanks

Jonas



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---

Reply via email to