Questions tagged [optimization]

Optimization is the process of modifying a system to make some aspect of it work more efficiently or use fewer resources.

A system may be optimized so that it executes more rapidly, or is capable of operating with less memory storage or other resources, or draw less power. The optimized system will typically only be optimal in one application or for one audience. For example, one might reduce the amount of time a task takes to perform at the price of making it consume more memory.

339 questions
-2
votes
1 answer

How to choose database and backend server locations?

I could not find a tutorial for beginners for how to locate my servers. For instance I use Compose.io for my MongoDB and DigitalOcean for my Meteor.js app. Lets say I want to have fast service in Germany. Now the closest I can get to Germany with…
Obiwahn
  • 99
  • 1
-2
votes
1 answer

Mysql Optimization For VPS

I've a bit in a problem optimizing my VPS's (Linux / Cpanel) mysql settings. I don'n know much about Mysql and I'm using this VPS for about 50 different websites. They all had below 100 visitors daily, so traffic not much my problem. My VPS working…
exspet
  • 1
-2
votes
1 answer

What webserver to use for a hentai website? Nginx or Apache?

I got a Linode VPS with 768MB. On another server (Speedysparrow), also with 768MB, i have Nginx running and it's awesome, as you can see here: http://www.ubuntubrsc.com/. This website, with the setup i talk about bellow, is using about 160~180MB…
-2
votes
3 answers

True or False: a table with large records (rows) and lots of fields (columns) will take longer to return a SQL query?

True or False: a table with large records (rows) due to lots of fields (columns) will take longer to return a SQL query? That is, if I have a SELECT ... WHERE...query in SQL that operates on a table that has many fields, and hence lots of big data…
PaulDecember
  • 5
  • 1
  • 1
  • 4
-2
votes
2 answers

how to optimize apache on web-server

how can I optimize the server with following configuration. It takes too much time to load a page. IBM X3200 M3 Server - 1 Intel Xeon Processor with 4 GB Ram Below is my current configuration for apache: Start Servers: 5 (Default) Minimum Spare…
-3
votes
1 answer

My website is superslow but the %CPU is only 25%

I have 2 servers for my website : One server 256GO RAM 20c/40t for MySQL One server 256GO RAM 20c/40t for Apache The MySQL server is always ok (30-50% of CPU is used). But the Apache server become SUPERSLOW when my website start to get 10,000…
-3
votes
1 answer

Choosing between which HTTP, DB, Optimization tools on a VPS server

I am finally moving from a Shared hosting to a VPS hosting on Digital Ocean. Since now I have control of what I can install, I would like to know which of these are preferred to install. Web Server Apache or NGinx? I learn that nginx is faster than…
Timmy
  • 109
  • 3
-3
votes
1 answer

Can postgres go faster?

My question is simply: have i missed any configuration settings that might make postgres achieve better read throughput? Background I'm modeling a very simple twitter program. My schema has only 3 tables: subscriptions, posts, and timelines. I have…
-4
votes
4 answers

What is the *optimal* virtual memory configuration for this server?

I am maintaining a Small Business Server 2003 (x86) server, that was originally installed and configured by someone else in early 2009. Recently, although we have never had any obvious memory-related performance issues, I have started to wonder if…
1 2 3
22
23