I am developing a project for which i am developing an application that collects smiple information from a visitor and enters it into a database which flash uses to demonstrate a graphical chart.
i have theorized the process as follow
user submits information via a form which is entered into a database using php/ mysql . Flash later calls php that dynamically generates a dynamic xml file from the mysql and fed back to flash.
my question arises from the flash aspect.
Now i am expecting at up to 10,000 entries for the database and i expect a considerable amount of traffic for the flash side.
I want to get some advice on what approach i should use considering the following factors of this process
- I have a target of 10,000 entries. is it feasable to have a php process to generate xml content on the fly from the mysql data to feed to flash?
- ok so im thinking to make an xml file before hand. this means that the xml file can get considerable big(10,000 entries). would it be feasable for flash to pull a file that may grow to a considerable amt?
- if i am to make an xml file it means i have to keep the data consistant with the mysql data. should i do this on a per entry basis. or would it be wise to regenerate the xml on a periodical basis(CRON job)
- in updating the xml file i have php 4.3.1. should i use a fwrite() and write to the file. or would the domxml functions be more suitable given the below point...
- Now i believe updating the xml file on a per entry basis would seem more suited but how would this affect the flash thats loads the xml when php is in the process of updating...
Kendall
if any of this is confusing ill be happy to further explain it.
i hope to get some feedback on this.