Skip to main content
Known Participant
July 9, 2008
Question

sending large structures to the browser

  • July 9, 2008
  • 1 reply
  • 264 views
I'm trying to create a registration page that will allow the user to create a profile and show where they live using a dynamic dependant select form. The form allows 1. continent selection 2. country selection 3. region selection. I have these working, and so far, the page seems to be loading quite quickly, even without caching the query (120 ms). But, I also want the user to be able to select their city. I will be loading three fields from a database (city name, country_id, and region_id). This dataset becomes quite large considering all notable cities in the world, and passing it to the browser causes great bog down (about 30 seconds). What do actual programmers do for sending large datasets to the browser (I'm not a programmer) btw, I am using q-forms by pengoworks to create the javascript structures/dynamic select menus (if that helps). Thanks for any suggestions!
dan
This topic has been closed for replies.

1 reply

Inspiring
July 9, 2008
It's the cities that are slowing down production. You can use related selects to get the countries once the user has selected the continent. From there you want another db query to get the cities for that country. This can be a page request or an ajax thing.

If you are not a programmer, you might consider hiring one to help you out.