best I guess would to "cache" your regions, state etc .... Then do not grab the associated region / state / city, instead use an element for displaying the information. The element can use the cached list of even be cached itself
On Oct 26, 12:01 pm, Paolo <[EMAIL PROTECTED]> wrote: > Hi all! > I have a problem using cake. I have a table that is linked to it's > geographical location > (i.e. house -> ... city_id > city -> ... region_id > region -> -... state_id) > In house index action I use findAll in all tables in order to show the > city, region and state in the list of houses. The problem is that I > have 8000 cities so i get out of memory error. Is there another way to > associate the id to the name of the city (region and state)? > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
