Re: [Flashcoders] >> 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
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;
idat.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
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Tim Consolazio
[EMAIL PROTECTED]

___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Re: [Flashcoders] >> load 500 by 500 from db in flash
Unsubscribe Remove
On Oct 19, 2007, at 11:11 PM, Ricky Bacon wrote:
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");
My SQL is rusty, but assuming you are using MySQL (no pun there...):
SELECT * FROM NP_socs_nancy WHERE soc_09='foo' ORDER BY soc_01
LIMIT 1, 500;
The LIMIT command uses [offset, max rows], so LIMIT 1, 500 would
start at row 1 and return 500 rows from the db. You can increment
the offset when the data has parsed successfully and query again.
-Ricky
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Re: [Flashcoders] >> load 500 by 500 from db in flash
Unsubscribe Remove
On Oct 20, 2007, at 5:44 AM, Jordan L. Chilcott wrote:
If you want to limit the number of your results, add LIMIT(0, 500)
at the end of your statement.
jord
On Oct 19, 2007, at 11: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");
Jordan L. Chilcott, President
Interactivity Unlimited
Guelph, Ontario
-
Tel: (519) 837-1879
Fax: (519) 837-8610
mailto:[EMAIL PROTECTED]
http://www.interactivityunlimited.com
iChat/AIM: j1chilcott
Skype: bear-faced-cow
SightSpeed: [EMAIL PROTECTED]
Author: "Building Web Sites with Macromedia Studio MX"
Author: "Building Dynamic Web Sites with Macromedia Studio MX"
Author: "Flash Professional 8: Training From the Source"
Author: "Foundation Flash 8 Video"
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Re: [Flashcoders] >> load 500 by 500 from db in flash
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;
idat.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
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Re: [Flashcoders] >> load 500 by 500 from db in flash
If you want to limit the number of your results, add LIMIT(0, 500) at
the end of your statement.
jord
On Oct 19, 2007, at 11: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");
Jordan L. Chilcott, President
Interactivity Unlimited
Guelph, Ontario
-
Tel: (519) 837-1879
Fax: (519) 837-8610
mailto:[EMAIL PROTECTED]
http://www.interactivityunlimited.com
iChat/AIM: j1chilcott
Skype: bear-faced-cow
SightSpeed: [EMAIL PROTECTED]
Author: "Building Web Sites with Macromedia Studio MX"
Author: "Building Dynamic Web Sites with Macromedia Studio MX"
Author: "Flash Professional 8: Training From the Source"
Author: "Foundation Flash 8 Video"
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
Re: [Flashcoders] >> load 500 by 500 from db in flash
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");
My SQL is rusty, but assuming you are using MySQL (no pun there...):
SELECT * FROM NP_socs_nancy WHERE soc_09='foo' ORDER BY soc_01 LIMIT 1, 500;
The LIMIT command uses [offset, max rows], so LIMIT 1, 500 would start
at row 1 and return 500 rows from the db. You can increment the offset
when the data has parsed successfully and query again.
-Ricky
___
Flashcoders mailing list
Flashcoders@chattyfig.figleaf.com
http://chattyfig.figleaf.com/mailman/listinfo/flashcoders
[Flashcoders] >> load 500 by 500 from db in flash
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;
ihttp://chattyfig.figleaf.com/mailman/listinfo/flashcoders
