Thread

I want to import 17000 cities into expression engine as categories.  Do you think expression engine can handle this? Where would I run into trouble?

Thanks!
Ryan

If you are able to successfully import those categories (and it shouldn’t be too hard at all with a knowledge of the database and a proper query), the real challenge would be displaying them in the control panel and in any sort of form element. Imagine creating a new entry and having to select from 17k cities. Not exactly fun. 😊

Before you do it, maybe you should consider some alternatives like each city being an entry and using relationships or some custom code. I don’t know anything about what you’re trying to accomplish, so this is simply general advice. You may have thought this all through already! 😊

thanks for your suggestions. Sounds like I could do it, but as you say - I should forget trying to access an entry or edit an entry in cpanel.

relationship entries could work.

I’m trying to organize an accomodation database and allow a user to drill down from country down to city to access the properties.

Does solspace’s tag module give you tag hierarchies? If so, it may be easier to deal with that than the default EE category list: http://www.solspace.com/software/detail/tag/

Instead of using categories, What if I used the search:field_name= in every weblog entries tag?

example:

URL of page is:  http://site.com/index.php/site/city/Miami/Florida/United States/

page would contain:

{exp:weblog:entries  search:city="={segment_3}" search:state="={segment_4}"  search:country="={segment_5}"}

{title}

etc….

{/exp:weblog:entries}

I know this is possible, My big question is whether it would be practical (to slow on the server?) because the search has to query through thousands of entries for each of the 17,000 city pages I have?

Thanks!