I would suggest to obtain all the data from a database.
Make a http service to call the php and obtain the data, and then just display a couple of items,
and make a next button and obtain the next items.
I think a great idea and even more so a great project to be involved in!
I have a question I like to ask ”Are you working with modules or is the project a single Application” ? I’m asking this because I assume you will have a lot of Image content to be displayed as well.
I agree with ‘alex-86’ to get your data predominately from a database (but would suggest also if the site is operated by a customer to use external Xml as this would be easier to be changed by them personally), and then obtain that data through a Http Service (if your data is not to bulky) and some Php. Definitely Php it could save you a lot of unnecessary Mxml and/orAS3 code and using Dom type Xml through Php works like magic.
In any case all the best of luck aktell
Hi, I have been working on al large school managing system.Of course, there's a pupil section, a course section etc. On startup, I'm loading all the lists which are crucial, but not all of it's data, just the data which have to be displayed in a list.
Example: In the pupil section, I send an remote request (I'm using remote objects with amfphp) like get_pupils which then triggers a mysql statement like:
$q = "SELECT name, surname, id FROM pupils";
$r = mysql_query($q);
This simple statement returns an arrayCollection of all the pupils. At this moment, we have about 10000 pupils in the database! The request takes about 1 second to finish. When clicking a pupil in the list, I send a new request to get all the information about that pupil.
We're working with databases which exceed 200.000 records (like the table which holds the information of which courses are followed by which pupils and so on.)
A few tips:
- Don't work with XML data transfer or HTTP requests. They take (much) longer! Use remote objects or webservices instead. Serialized data streams are much smaller.
- Make intelligent sql statements which return complete datasets instead of looping through them on the server side. A good query might take 0.04 seconds to finish, a bad one several seconds!
- Use MVC patterns to keep good overview of your application.
Hope this helps,
From the replies so far, I can see that a little more information about my project is in order:
For this project, I am working from a merchant datafeed, so I already have database tables with all the product and food category data – I also have the URLs to all the images – and actually the images on my server. So archemedia, I have no problems bringing the data from my ColdFusion server into Flex – a recordset of 1200 rows is nothing.
My concern and the bottleneck here is creating and displaying many thumbnails at one time. I have to rule out creating and displaying "All Categories" the equivalent of "All Series" in the Flexstore sample (see mi original post on this thread) – that works fine in the sample with its total of 18 products, not so well when you have 1100+ items to display. That is really the part of this project about which I need advice.
Here is what I am thinking: starting out selecting and displaying X category (one with no more than 75-100 products). Then, bringing in one category at a time, as the user selects them in the ComboBox. I guess I will have to split categories containing over, say 100 products into smaller subcategories.
It helps to just hear feedback, so I want to thank all of you who have already replied. And y'all please keep those ideas coming, ya hear?.