Re: >> load 500 by 500 from db in flash

I'd make sure your sql is tuned really well (I'm not a SQL expert so =20
I always seek somebody that is), make sure you are only returning =20
data you need (don' t return columns with data you don't need, SELECT =20=

* can be evil), and failing all that (and failing moving to remoting =20
or something), partition your calls so that you don't do it all at =20
once (first call for range A-M, then N-Z, or some such partition =20
scheme that works).

On Oct 20, 2007, at 6:01 PM, Rich Rainbolt wrote:

>
> On Oct 19, 2007, at 8:29 AM, CARABUS-Plus wrote:
>
>> Im using FLASHSQL to load data in flash from php db
>>
>> Theres is too much data to load, how can I do to load 500 by 500 =20
>> result ?
>> Thank you
>>
>> myFlashSQL.Execute("SELECT * FROM NP_socs_nancy WHERE soc_09 =3D
>> \""+categ_var+"\" ORDER BY soc_01");
>>
>>
>> Laurent
>>
>>
>> And the listener :
>>
>>
>> var myListener1:Object =3D new Object();
>> myListener1.dataLoaded =3D function(success:Boolean, xmldata:XML) {
>>     if (success) {
>>         trace(xmldata);
>>         if (comStatus =3D=3D "loading") {
>>             display.removeAllColumns();
>>             display.columnNames =3D ["Sp=C3=A9cialit=C3=A9", "Nom", =
"Ville"];
>>             display.getColumnAt(0).width =3D 120;
>>             display.getColumnAt(1).width =3D 100;
>>             display.getColumnAt(2).width =3D 115;
>>             var dat:Array =3D new Array();
>>             _root.finder_txt.text =3D "il y a
>> "+xmldata.firstChild.childNodes[3].childNodes.length+" r=C3=A9ponses";
>>             for (var i:Number =3D 0;
>> i<xmldata.firstChild.childNodes[3].childNodes.length; i++) {
>>
>> dat.push({Sp=C3=A9cialit=C3=A9:unescape(xmldata.firstChild.childNodes=20=

>> [3].childNodes[i]
>> .childNodes[14].childNodes),
>> Nom:unescape(xmldata.firstChild.childNodes[3].childNodes=20
>> [i].childNodes[4].ch
>> ildNodes),Ville:unescape(xmldata.firstChild.childNodes=20
>> [3].childNodes[i].chil
>> dNodes[8].childNodes),Tel:unescape(xmldata.firstChild.childNodes=20
>> [3].childNod
>> es[i].childNodes[9].childNodes),Fax:unescape=20
>> (xmldata.firstChild.childNodes[3
>> ].childNodes[i].childNodes[10].childNodes),CP:unescape=20
>> (xmldata.firstChild.ch
>> ildNodes[3].childNodes[i].childNodes[7].childNodes),
>>
>> Rue:unescape(xmldata.firstChild.childNodes[3].childNodes=20
>> [i].childNodes[6].ch
>> ildNodes),eMail:unescape(xmldata.firstChild.childNodes=20
>> [3].childNodes[i].chil
>> dNodes[11].childNodes),
>> lat:unescape(xmldata.firstChild.childNodes[3].childNodes=20
>> [i].childNodes[16].c
>> hildNodes),lon:unescape(xmldata.firstChild.childNodes[3].childNodes=20=

>> [i].child
>> Nodes[17].childNodes),lic:unescape(xmldata.firstChild.childNodes=20
>> [3].childNod
>> es[i].childNodes[19].childNodes)});
>>             }
>>             display.dataProvider =3D dat;
>>         } else if (comStatus =3D=3D "sending") {
>>             msg =3D "Data Sent Successfully. You can now reload!";
>>         }
>>     }
>> };
>> _______________________________________________
>> Flashcoders mailing list
>> [email protected]
>> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
>
>
> _______________________________________________
> Flashcoders mailing list
> [email protected]
> http://chattyfig.figleaf.com/mailman/listinfo/flashcoders

Tim Consolazio
[email protected]

=EF=BF=BC

_______________________________________________
Flashcoders mailing list
[email protected]
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders