# Performance issues with multiple queries (XML/php/Flash) **URL:** \ **Category:** flash\ **Created:** [October 4, 2004, 12:21pm UTC](https://forum.kirupa.com/t/performance-issues-with-multiple-queries-xml-php-flash/66265 "2004-10-04T12:21:38Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![CoolDuck](https://avatars.discourse-cdn.com/v4/letter/c/d9b06d/32.png) [@CoolDuck](https://forum.kirupa.com/u/CoolDuck)\ **Post date:** [October 4, 2004, 12:21pm UTC](https://forum.kirupa.com/t/performance-issues-with-multiple-queries-xml-php-flash/66265/1 "2004-10-04T12:21:38Z")
Hi 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. [COLOR=Navy] 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. [/COLOR] 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 hope someone has some tips for me on this matter! How to deal with 3 XML queries… This is the link if you need to know what I’m talking about: [http://www.eyecatchers-models.com/v1/](http://www.eyecatchers-models.com/v1/) Thanks in advance!