Q2A Performance Reports

Question

Can someone tell the reason for "Other" mentioned here? Does it include the file access times?

Comments

What do you use for hosting?

---

Not due to hosting. This is happening only for a custom page which is from a plugin and not Q2A fault. Just need to know the reason for 'Other'. And my hosting is AWS.

Answer 1

I believe it includes everything outside the PHP code itself or MySQL. So it would include reading files from disk or network requests.

I’m not sure off the top of my head but I think the MySQL section only includes usage from Q2A functions (qa_db_*). So if a plugin calls MySQL using the native mysqli_* functions it may count in “Other” too.

By the way if you want to get detailed performance info I’d recommend trying the Xdebug profiler alongside webgrind (or kcachegrind). It will show you exactly which functions take the most time.

Comments

Thanks Scott. That makes it easier. I'm reading a google doc file -- it must be the reason for slowdown.

---

Yes that sounds likely. What are you using to read the file? Are you fetching a URL or using an API? Maybe there are faster ways, or you could cache the file locally for a while.

---

Currently I'm fetching the URL. I think I can just store the contents in the database with periodic updates from the URL.

---

Just confirmed that it is indeed the URL fetch. Was a bad method :)