1 Reply Latest reply on Jan 7, 2008 7:39 AM by Newsgroup_User

    Designing a dynamic tracker, Need advice...

    ultrajeeps
      Hello Everyone,

      I am in process of designing a BMI tracker which would allow users to track their BMI for 52 weeks. I am designing it in FLASH but would like to capture the entered data by the user to a database (MS ACCESS or SQL). I will probably add more features which would also dynamically driven via DB. My questions are:

      1. I am assuming I will be using ASP.NET with SQL or ACCESS, would it be easier to have DB spit out XML and then I populate that data in FLASH?

      2. Since this tool will be online, having a database spit out XML for each request can probably bog down the server performance (I can be wrong here). Should I not use XML?

      3. Are there any off the shelf tracker tools available which can customized?

      4. What other technologies can I use to achieve this tool using Flash?

      Thanks a lot for all your help.

        • 1. Re: Designing a dynamic tracker, Need advice...
          Level 7
          1. I am assuming I will be using ASP.NET with SQL or ACCESS, would it be
          easier to have DB spit out XML and then I populate that data in FLASH?

          I'd use PHP and MySQL instead, but that's what I'm more comfortable with. No
          reason for the intermediary XML step, unless you have a special need for it.

          2. Since this tool will be online, having a database spit out XML for each
          request can probably bog down the server performance (I can be wrong here).
          Should I not use XML?

          I wouldn't. You could use LoadVars to get the data directly from your
          script. But, personally, I'd use AMFPHP ( http://www.amfphp.org/) which is an
          easy to use remoting replacement that runs on PHP. It's much faster than
          LoadVars and serializes your data for you.

          3. Are there any off the shelf tracker tools available which can
          customized?

          Can't help ya there.

          4. What other technologies can I use to achieve this tool using Flash?

          Many... Java, JavaScript, Director, VisualBasic, etc, etc, etc.

          --
          Dave -
          Head Developer
          http://www.blurredistinction.com
          Adobe Community Expert
          http://www.adobe.com/communities/experts/