Questions tagged [optimize]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
25 views

Optimizing sales in excel/google sheets

I have a table that looks like that: investment p1 p2 p3 1000 100 50 80 2000 200 60 95 3000 300 70 110 4000 400 80 125 5000 500 90 140 6000 600 100 155 7000 700 110 170 8000 800 120 185 ...
0
votes
1answer
15 views

Optimizing the running speed of a large table with many formulae

I have to make an Excel-based calculator for other users. This works really simply, it just has to tell does a cell include certain letters or not. The calculator is basically a large table (...
0
votes
0answers
12 views

Optimize time when creating archive

Currently, I am using the following command to create an archive with files older than 7 days: find /var/tunningLog/ -type f -mtime +7 -print0 | tar -czf "/var/tunningLog/$(date '+%Y-%m-%d').tar....
1
vote
0answers
29 views

Optimize batch script to create set of subfolders upon folder creation [closed]

This is my first post in here. I'm quite noob in this field, so sorry if I ask any uber basic questions... The case... So, I need to create a batch file which asks for a project number and name, and ...
1
vote
1answer
41 views

Optimizing item position using in a warehouse excel formula

I currently am in need of an excel formula or way to do this simple optimization to sort items by popularity. Context: The image is a top-down view of course, each square is a product we sell, and ...
1
vote
2answers
67 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
2answers
155 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 ...
1
vote
2answers
5k 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 ...
1
vote
0answers
35 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
108 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
682 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
950 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 ...
47
votes
2answers
23k 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
715 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
1k 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
740 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
381 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
853 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
87 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
375 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
3answers
5k 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
471 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
29k 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 ...