Over the past couple of weeks we have had increase page load times on our
website and while running certain pages on our AppEngine setup.
The problem comes when doing anything with the Cloud SQL Database from
AppEngine.
We have narrowed down the problem by running the following test
Run the same PHP page on both Compute Engine (via Cloud SQL Proxy) and
AppEngine
Result (Compute Engine)
1539768438.6956 :: Starting...
1539768438.6960 :: Set order xxxx-xxxxxx-xxxxxx-xxxxxxx as printed
153976843*8.69*60 :: - Updating cbd
153976843*8.71*48 :: - Updating printing_flag
1539768438.7165 :: - Done
Speed: 0.02 Seconds
Result (AppEngine)
1539768392.9724 :: Starting...
1539768392.9725 :: Set order xxxx-xxxxxx-xxxxxx-xxxxxxx as printed
153976839*2.97*26 :: - Updating cbd
153976839*3.15*58 :: - Updating printing_flag
1539768393.2043 :: - Done
Speed: 0.18 Seconds
The "Updating printing_flag" section is attempting to delete an entry that
does not exist, in a table that has less than 200 rows in it, and this on
AppEngine is still taking a lot of time compared to Compute Engine.
PHP Page:
addLog('Starting');
//Loop
addLog('Set order ' . $o->basket_id . ' as printed');
// Do the setting of this basket when we want it to be saved
addLog('- Updating cbd');
db_q("UPDATE cust_basket_detail SET basket_printed = '".date('Y-m-d
H:i:s')."' WHERE basket_id = '".addslashes($o->basket_id)."' LIMIT 1"); //
[130,000 Rows]
addLog('- Updating printing_flag');
db_q("DELETE FROM printing_flag WHERE basket_id = '" .
addslashes($o->basket_id) . "' LIMIT 1"); // [200 Rows]
addLog('- Done');
These timings used to be identical until a couple of weeks ago.
There is no load on the AppEngine instance as this is a new version freshly
built, and the page loaded a few times with the same result.
--
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-appengine.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-appengine/9282eaca-09e8-44de-af0d-47850d5b8aec%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
