Flash and MySQL

[Anshakov]

Hello guys.
Question:
I have transfer data form flash to MySQL and again to flash as soon as it possible:
Flash(text1 field)->MySQL (save "text1" in the database field "text" and return to flash as text2. We read this again from "text" field of database)->Flash
P.S. text1 and text2 field in the _root.charactermovie of cause.

Here is a flash-script for _root.charactermovie:
onClipEvent (enterFrame) {
loadVariables("text.php", "_root.charactermovie", "POST");
}

enterFrame event to cycle event of cause.

Php-script:
<?php
require( "function.php" );
$dbLink = mysql_connect( $dbHost, $dbUser, $dbPass );
dbConnect();
mysql_query( "UPDATE text SET text='$text1' where id = 1;" );
$result = mysql_query( "SELECT text FROM text where id='1'" );
$row = mysql_fetch_array( $result );
$text2=$row['text'];
echo "text2=".$text2;
?>

All is working, but... with such slow speed...it’s refresh in 1 sec or even worth.
Is there flash problem or is there mistake in my head? :-)

Regards,
Alex

[Musicman]

Hi,

while you are reading flashkit, just measure the time it takes a loaded server to, e.g., follow a "next thread" link - this will be seconds.
Now, with the enterframe approach, you are creating one request to the server per frame, even if you do not need that many chnges. If this happens on a public server, nd a few people do the same, it will soon be as loaded as the fk forum

Unless your setup can work with a reasonable refresh rate (e.g. 2 seconds after result from previous call), you should start investigating about socket servers. In order to achieve the timing mentioned, you would probably use an onclipevent(data) storing the gettimer() into a variable, nd the onclipevent(enterframe) comparing that variable to gettimer()

Musicman

[LuxFX]

Although it should also be noted that even socket servers aren't all that fast. Flash doesn't necessarily send data right after you tell it to. The manual says:

The send operation is asynchronous; it returns immediately, but the data may be transmitted at a later time.

Not exactly encouraging.