I'd make sure your sql is tuned really well (I'm not a SQL expert so
I always seek somebody that is), make sure you are only returning
data you need (don' t return columns with data you don't need, SELECT
* can be evil), and failing all that (and failing moving to remoting
or something), partition your calls so that you don't do it all at
once (first call for range A-M, then N-Z, or some such partition
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
result ?
Thank you
myFlashSQL.Execute("SELECT * FROM NP_socs_nancy WHERE soc_09 =
\""+categ_var+"\" ORDER BY soc_01");
Laurent
And the listener :
var myListener1:Object = new Object();
myListener1.dataLoaded = function(success:Boolean, xmldata:XML) {
if (success) {
trace(xmldata);
if (comStatus == "loading") {
display.removeAllColumns();
display.columnNames = ["Spécialité", "Nom", "Ville"];
display.getColumnAt(0).width = 120;
display.getColumnAt(1).width = 100;
display.getColumnAt(2).width = 115;
var dat:Array = new Array();
_root.finder_txt.text = "il y a
"+xmldata.firstChild.childNodes[3].childNodes.length+" réponses";
for (var i:Number = 0;
i<xmldata.firstChild.childNodes[3].childNodes.length; i++) {
dat.push({Spécialité:unescape(xmldata.firstChild.childNodes
[3].childNodes[i]
.childNodes[14].childNodes),
Nom:unescape(xmldata.firstChild.childNodes[3].childNodes
[i].childNodes[4].ch
ildNodes),Ville:unescape(xmldata.firstChild.childNodes
[3].childNodes[i].chil
dNodes[8].childNodes),Tel:unescape(xmldata.firstChild.childNodes
[3].childNod
es[i].childNodes[9].childNodes),Fax:unescape
(xmldata.firstChild.childNodes[3
].childNodes[i].childNodes[10].childNodes),CP:unescape
(xmldata.firstChild.ch
ildNodes[3].childNodes[i].childNodes[7].childNodes),
Rue:unescape(xmldata.firstChild.childNodes[3].childNodes
[i].childNodes[6].ch
ildNodes),eMail:unescape(xmldata.firstChild.childNodes
[3].childNodes[i].chil
dNodes[11].childNodes),
lat:unescape(xmldata.firstChild.childNodes[3].childNodes
[i].childNodes[16].c
hildNodes),lon:unescape(xmldata.firstChild.childNodes[3].childNodes
[i].child
Nodes[17].childNodes),lic:unescape(xmldata.firstChild.childNodes
[3].childNod
es[i].childNodes[19].childNodes)});
}
display.dataProvider = dat;
} else if (comStatus == "sending") {
msg = "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]

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