Questions tagged [optimize]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
62 views

How to sort two columns of numbers to minimize the differences between them?

I'm sorting two columns of numbers. One is a series of spools of wire, and another is a series of needed lengths. I want to optimize the selection of spools for the needed lengths, while flagging ...
0
votes
0answers
15 views

Questions about Optimize MySQL

Can I run optimize with the system in operation? My tmpdir, defined in my.cnf.d/server.cnf is /tmp. Because I can identify the increase in /tmp but inside the directory, I can't identify what is ...
0
votes
0answers
30 views

Jpegoptim on Xubuntu 16.04.6

I'm using jpegoptim to optimize jpg images, it works flawless, but I have one question about optimize multiples jpg images using a short script: n=1 for i in *.JPG; do jpegoptim --max=25 "$i" $...
-1
votes
2answers
73 views

Do Windows memory optimizers actually work (on Windows 10)? [duplicate]

Note: this is not an opinion based question, and I do not want any opinion based answers. Microsoft have had long enough by now to optimize Windows, build in garbage collectors, etc Does anyone know ...
0
votes
2answers
1k views

What does Piriform Defraggler's “Optimize” option for SSD do?

I regularly used Piriform's Defraggler to defrag my hdd. Switching to SSD, I thought it was no more necessary, as SSDs do not require defrag. I used it to make a benchmark, and the program proposed ...
0
votes
0answers
19 views

Division remainder restriction in Solver

Could anyone tell me how do I create a restriction in Excel Solver in which the remainder when dividing by 50 must be 0?
1
vote
0answers
31 views

How can I use MatLab to optimize based on relative rank?

This is a problem that I have previously addressed in Excel, but would like to move to MatLab for better quality solutions. Where I work, there is a semiannual process to rank new initiatives. They ...
1
vote
1answer
90 views

Excel - VLoolup with Match - Is This an Optimal Solution?

I'm trying to avoid the redundancy of calculating the same index as many times as there are records, so should I pre-calculate the index with MATCH in a hidden cell above my table? It is also worth ...
1
vote
2answers
497 views

Optimize For Each loop on Pivot Table

I am having a hard time trying to optimize a VBA For Each loop that has to parse 10-15k rows in a PivotTable which is based off an Excel Table, all in the same workbook. Currently this takes about 2 ...
0
votes
1answer
837 views

How do I optimize MySQL Server for better performance? [closed]

Recently I had to work with a legacy system. Working with it took a lot of my time because many of the tables were not normalized properly. Due to maintenance issues it is impossible to change. My ...
29
votes
1answer
13k views

Optimize animated GIF size in command-line

How to compress GIF animations? For example by reducing the color index. The files are generated using Imagemagick but optimization seems complicated. For example, the following animation is 864KB ...
2
votes
0answers
584 views

Win 8.1: Defrag Optimize Issue: Do you want to restore default optimization settings?

Optimize Drives Do you want to restore default optimization settings? Storage optimization is currently using customized settings created by another program. Before you can modify the ...
1
vote
2answers
890 views

How to optimize a VBA function in Excel

I wrote a function in VBA and have provided a simplified version below. Basically, it takes an argument, preforms a vlookup on a named range in the sheet using the value of the argument, passes the ...
0
votes
0answers
90 views

Any 'Server mode' for El Captain

We have a virtual machine on vSphere with OS X El Captain installed, which serves as CI server (runs Jenkins instance for building apps we develop). However, virtual machine looks to be about low-...
0
votes
1answer
527 views

How do I make sure my code is compiling with -o3 in gnu make?

I have a huge Makefile I'm working with and trying to trim down. Right now, it's layed out to build several different programs with tons of options I'll never use. My hope is to first make sure the ...
0
votes
1answer
366 views

Shared hosting: how do they estimate server CPU usage? [closed]

I'm using several shared hosting services and wondered many times: how do they calculate those "CPU seconds"? For example one of those limiting me with 300,000 seconds/month, 10,000 seconds/24h and 2,...
2
votes
1answer
796 views

What are exact settings in Adobe Acrobat “Reduced Size PDF…” relative to “Optimized PDF…”?

Does anybody know what are the exact settings whne saving a PDF document in "Reduced Size PDF..." vs. saving it in "Optimized PDF..."? I know "Optimized PDF..." has different modes like Standard, ...
-1
votes
1answer
86 views

Installation Optimisation With Limited SSD Space

Tomorrow, I need to rebuild a windows 7 machine due to various issues. It currently has a 500GB HDD as the primary drive, with a 120GB SSD. As a developer, I need to keep as much space free as I can ...
0
votes
1answer
349 views

Windows7, defragment swap and hibernate file and move them to begin of hdd

I tried find any tool for windows7 that help me with defrag swapspace, and move them to beginning of volume. I have no option to create separate partition for swap only, because I have 4 primary ...
3
votes
2answers
4k views

Gentoo LDFLAGS optimizations really needed?

I'm using Gentoo Linux. Here is my toolchain: sys-kernel/linux-headers-3.9 sys-devel/binutils-2.23.1 USE="cxx nls zlib -multislot -multitarget -static-libs {-test} -vanilla" sys-devel/gcc-4.7.3-r1:...
2
votes
0answers
50 views

Schedule Optimization [closed]

I am trying to plan a complex trip that I have to take soon. There are some issues that are making the trip difficult to plan: There are several stops There are time constraints for both the whole ...
0
votes
2answers
466 views

MacBook Pro 15 Early 2012 very slow

My Mac machine, is becoming lazy day by day.. booting it takes around 50-130 seconds. No idea how to fix it or do I need to run any optimization software? Machine freezes also and eats RAM too much ...
6
votes
1answer
28k views

Windows 8 will not defrag or analyze system hard drive

I recently bought a new laptop that runs windows 8. It has been about a month and I wanted to clean the system up a bit to keep it running smooth. I tried to defrag the system hard disk drive but when ...
0
votes
2answers
5k views

How to remove unwanted background processes?

Since I installed iTunes to manage an iPhone 3GS and the software manager for a Motorola Droid smartphone, I have the below processes run all the time: How can I remove the processes so they do not ...
8
votes
5answers
3k views

Intel RAID0 on Windows 8 not Displaying Correct Media Type

I have my primary C Drive which consists of 2 Intel 120GB SSD Drives in a RAID0. I have a clean install of Windows 8 Pro, latest MEI software, latest RST software, latest Intel Toolbox. Prior to this ...