ActionScript 2.0 :: Performance - Retrieve Information Of Different Tables In Mysql?
Oct 4, 2004
I'm building a Flash website with database information with php>mysql>xml>Flash mx 2004. I'm having some major problems!I need to retrieve information of different tables in mysql, and was worried about performance issues.The first query gets the whole model list...The second query will be performed after a model is clicked. Something like: select * from modelinfo where modelID=modelIDinFlash.
The third query is what I have a lot of trouble with! This has to run on the same time or immediatly after the second query. It reads the picture urls and id's from that particular model. I need the filenames for the picture viewer.But everytime I try this third query, the site becomes very slow and have problems displaying the model info.NOW I have a temporary solution: in the first table I have a field which states how much pics each model has, and this number Flash uses to build the nr buttons. But this is not a very solution since I want to keep everything dynamic. I also want to build a drag and drop function... something like a shopping cart. For that to work, every picture must have an unique ID.
I am trying to save the information for a layout of movie clips on my stage. I am using the sqlite functionality in order to be able to save the layout to the local database. Each layout consists of several movie clips. My plan was to store pertinent information regarding these movie clips (such as x and y position) in order to be able to reload some new clips in the exact same place.
My problem here is that I want to create just one row in my database for each layout, but I want one column in that row to store the information for each of those clips (in a single row). Is there some kind of nested table functionality in sqlite?6564
I use flex and php to retrieve information from my sql database. What i have been doing is formatting the result from the database query into xml and then putting the result into an arraycollection. It all works fine except one of my database fields contains a lot of text that website users enter and as xml doesn't like tags like <> so I leave it un formatted but I would like to format it. Would I be better using flashvars or text than xml? Or is there another way?
I load image - and need its width and height in global variables, i dont know the image width and high that will be loaded; does enyone can explain me why it get NaN NaN or 0 0 or how can I retrieve this information outside from function loadComplete()?
I am trying to retrieve some information back from my LMS and into variables in Flash with AS3. I used to be able to do this without any problems in AS2, but can't seem to find a way to make this work in AS3. In AS2, publishing with the "Flash with SCORM 1.2 Tracking" option, I could call a line like the following:
This would grab the student name from the LMS and store it in Flash in the variable named stuname.
Any way to do this with AS3? I can set values back to the LMS no problem still through fscommand such as score or completion, I just can't get anything back from the LMS such as student name or lesson location.
I am currently using the latest verion of Adobe Flash Builder to create a Mobile Application. For the application one feature is to allow the users to bookmark content an this is done by storing the id of the object to be Bookmarked into an SQLite db on the device. This part has been done successfully and they are stored fine.
Now what I want to do is to pull back the bookmarked id's from the database and pass them to a WebService call which needs to be made to an External Database. When I retrieve the Bookmark id's from the local database they are contained within object, I now need to find a way to take the id's from the database objects in the ArrayCollection and store them in a new array that will be passed to the WebService, as the webservice is expecting an Array of Int's and not Objects. Below is the code I created to see if the object items are within the array list of objects:
how to retrieve information about size (in pixels) of loaded FLV file? Video object returns 2 pairs of parameters (width,height) which are useless because returns always parameters passed in constructor of Video() object. Another pair is (videoWidth,videoHeight) which is always (0,0). I gave up...
I need this information to scale proportionally video clip to size of area designed to display this video.
Currently I'm setting up a webservice, which includes a login to access the member area.I'm testing all components seperately, and I've ran into a problem. When the user logs in I want flash to retrieve the user_id as a variable, so that I can use this user_id for member related database access. However, I'm having problems with retrieving the user_id.The login is done by inputting the email and password of the user. If these variables match the data in the database the user is send to the member area. I want to get the user_id by posting the email variable to a php file. In the php file the following code is responsible for this:
I'm having a little trouble with the 3. I'm trying to use a URLRequest to get login information from the mySql server. It works great when I try to log in, but if anyone else from outside my network tries to log in, it just hangs. I'm on port 8080 using localhost. I've even tried changing everything to my IP address instead of localhost and allowing my tester to try, but it still hangs.
How to connect to MYSQL DB from Java, create table, insert data, retrieve it with datatypes. How to make use of the data to/from in Flex application. i have basic knowledge in sending and receiving messages using BlazeDS.
I need to create a login page in my flash site that relates to information input to a mysql database. after the submit their information we want to send them a link to a differnt flash page with a login screen they will use their first name and a password (already in our database) to gain access to this "new" page. on that page there will be a welcome message that says "Welcome, User First Name" so I guess i have two questions
1: how do i set up a login page?
2: how do i pull that login info to a welcome page?
Using FDT, when I have a debug configuration with several operations in the launcher chain and the final launcher opens in Flash Player, how can I retrieve the build output from the console once the build is complete and Flash player is running?
It seems that once Flash Player has started the console clears to make way for the application's trace output, but I need to be able to look back over the events and build times for each item in my launch chain while Flash Player is running. Is there a setting I can enable to either log my build output to a file or to preserve it in the console?
Edit: I know I can still read the info when building normally, this question is specifically for building with the debugger.
I'm devloping some library classes for flocking/steering behaviours on large numbers of objects (2000+). I'm finding that at < 500 instances, performance is reasonable. As the numbers increase, framerate bogs down.
I've seen remarkable performance with libraries such as Flint or Box2D with ridiculous #'s of particles / objects, so it should be possible to optimize / refactor my code to be a bit better.
I'm aware of the basic optimizations, such as bitwise operations and optimized for loops. Are there any more fundamental approaches I should be considering? For example, currently each instance is a vector-based MovieClip. Would working with BitmapData be more efficient?
Will I take a big hit in performance using nested ViewStacks? Should I strive to handle all navigation in one ViewStack and push children manually or will the affected performance be negligible?
We have a medium size Flex 3.6 application that contains around 20 different page views (managed via a single lazy ViewStack) each having multiple components. Most use custom renderers.All model data is loaded at startup and changes to model instances are communicated via binding and/or collection change events.Once the user has viewed each page at least once, all page views are instantiated and happily listen to update events.Which in effect means that each time a model instance changes, all interested views receive that event and compute derived data or trigger item-renderers.I have tested and confirmed this behaviour in a proof-of-concept application. Even when setting a list to being invisible, it still listens to collection change events and invalidates any renderer affected.What would you do?
I'm kinda noobish when it comes to getting information from XML information sent to my flash file from the socket server. OK so for example the server sends me this:
[Code]...
I want to get the name of the user and the X and Y position! Is there a way I can get this information without a load of fuss from functions and other junk remember im kinda noobish.
I want to build a program built around my pc specs. Is there a way to access such information as how much ram I have or how much cpu usage is being consumed, etc.?
I have a typical Flex-based application that was written to use a Java/Hibernate/MySQL backend. The client changed the requirements - now they want to distribute it on a CD where the user can just run the app without any installation or a network connection.
To do this, I certainly need to eliminate the web server and the database server and adapt my application (with as few changes as possible, of course) to a stand-alone application that will fit on a CD/DVD. I've managed to export the data to XML and read it into Flex, but I'm wondering if there's a way to recreate the Hibernate data structures in Flex so I could change as little code as possible. Failing that, is there any way to keep the existing Java/Hibernate external to the Flex code but retrievable without installing Apache Tomcat or MySQL?
I have a Flex application which manage a database composed by 7 tables.I have created the insert form and all work great. Now I wanto to improve the Form performances; the idea is to replace the TextInput of the Form with ComboBoxes which are provided by the DataBase tables
I can't figure out for the life of me why I can't get this to select all tables. If I select a specific table it works..
[Code]...
It seems like this should be working because in the documentation it says, "If a result expression is * then all columns of all tables are substituted for that one expression. " here is the docs. [URL]
I need to create a 3-column 10-row (sometimes up to 12) table in Flash. I don't need any sorting or resizeable colums or anything like the DataGrid component offers. I'd be happy with 30 dynamic text fields, but that doesn't seem like the right way of doing it.I can make an XML document or an HTML page (although flash can't load HTML pages/tables if I understand correctly? Only basic html). I think XML would be easiest. This is for data that is reloaded every 15 seconds, so it needs to be somewhat efficient.Currently I am just loading htmltext using loadvars, but the problem is that I can't align the 3 columns.[code]
I am using a html parser [URL].. to render several tables into a movieclip.My problem is: as it takes some time to render, the only one actually being added to the movieclip is the last one. I would use a timer, but that means I would need to call a function, and I am using a "for" loop to build the movielips. Is there a way to say "wait for x seconds before continuing processing" in ActionScript3?
I want to basiclly create a spot the differance game but instead of the user being able to just click on side of the pictures to get the answer, i want them to click on one picture and than the other picture to get the answer. So basiclly they have to click on the picture on the left and than on the right to mark something as a answer which would link both pictures. Or another example, is linking two tables. If i had two tables up and the objective was for the user to link one line of the table to another on the other table, it would link and draw a link from one side to the other showing the link.
I have a flash project that connect with a server. I get all data from the server as raw tables as XML. So I have to do the server logics client side. (Don't ask why!)
I have looked for a framework or some code base that have solved this. A framework that can do mapping of keys asf. Basically a frame work that stores the data and handles retrieving of the data like SQL.
Ie. I can get user with the userid without iterating through all the instances. This gets more complex when you have more id in the same table.
So is there a data framework for flash out there?
(the HTML 5 sqlLight would be great if more browsers supported it)
I'm using a font that has a kerning table with a TextField object to display text. However, it appears the kerning table is never being used.[code]I figured kerning=true would force the text field to abide by the font's kerning table. If I use the same font with the new Flash text rendering engine it seems to respect the kerning tables as expected, but at this point we can't switch to the new rendering engine.
