New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
Meanwhile in the real world WordPress uses 20 to 40 queries per page
http://www.dev4press.com/2011/blog/benchmark/wordpress-benchmark-3-0-vs-3-1-vs-3-2-vs-3-3/
other CMSes up to 35-40 in default install http://stackoverflow.com/questions/342504/is-20-sql-queries-per-page-load-really-considered-a-lot
But of course, go ahead and spend time rewriting your CMS or switching to a different unfamiliar one just so that you can use MySQL from the other side of the globe.
Besides, the provider's backups, will almost never match your timing and they are general dumps, ie, bare metal restore in case all the raid went down the drain for some fire or something.
@Pats @prometeus is doing this project, I have nothing to do with it, only with the storage right now
ahh.. who said that?
i myself tell my hosting clients that backups are done weekly but still they should also backup their data for any worst case scenario.
Dunno, clients of a provider who went down together with their backups?
Anyways back to topic:
@Maounique @prometeus
I miss a security feature to restrict connection to MySQL by the client's IP address.
Can this be implemented?
Thanks M for the great explanation
http://www.dev4press.com/2011/blog/benchmark/wordpress-benchmark-3-0-vs-3-1-vs-3-2-vs-3-3/
I'm not talking about the NUMBER of queries? I was simply saying they are batched up and not executed 1 by 1 so the latency equation works differently.
Must it be used with a Prometeus VPS or can we buy it separately and use it external i.e. with EDIS
I think the usermin/virtualmin interface don't support this feature in the current version. I will check it.
You can use it from everywhere :-)