Hello I've been developing an php+sql app. app engine ver. 1.9.31 ( tuunix-tuntileimaus.appspot.com/indexm.php )
that is working many times very slow. I am paying to get the second smallest cloud sql instance (more memory) and have set the instance to be running all the time. So it should not be restarting after idle perioid. I have also set daily limit, but i think that it wont matter because there are no users for the app currenly so it should be free from the app engine part. "Billing status Enabled (Daily budget: 0,00 $ boosted by 0,50 $) Settings" For loading the initial php-screen (affter logged in) I need to check the user session and validate it (from sql) then I need to load the data using simple left join that works smooth from mysql, but not from cloud sql. How can i make it faster? it is crucial that the loading screen is fast! I could copy some of the data to a faster read-only database if it's easy to use but i don't want to change whole app for another sql. Here are couple logs: 09:58:02.130 200 8,36 KB *3,34 s* /indexm.php 37.219.169.33 - - [12/Jan/2016:23:58:02 -0800] "GET /indexm.php HTTP/1.1" 200 8558 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36" "tuunix-tuntileimaus.appspot.com" ms=3337 cpu_ms=21 cpm_usd=0.0009564310000000001 instance=00c61b117c63aaef224186a3798ac27fa23xxx app_engine_release=1.9.31 trace_id=c46a5c43610c5bf97d758acf9d444f85 09:58:31.555 200 367 B 275 ms /setworktimecomment.php 37.219.169.33 - - [12/Jan/2016:23:58:31 -0800] "POST /setworktimecomment.php HTTP/1.1" 200 367 - "Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36" "tuunix-tuntileimaus.appspot.com" ms=275 cpu_ms=20 cpm_usd=4.1015e-05 instance=00c61b117c63aaef224186a3798ac27fa23xxx app_engine_release=1.9.31 trace_id=92b17ea4ba9f003a735fa58f2465ba67 Trace: http://tinypic.com/r/15xv605/9 What should I do ? -- 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 google-appengine+unsubscr...@googlegroups.com. To post to this group, send email to google-appengine@googlegroups.com. 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/7ad1ec3d-4c5b-426a-8071-f5f9be4e36e4%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
