Questions tagged [optimize]
The optimize tag has no usage guidance.
29
questions
0
votes
0
answers
125
views
How to score RAM based on timings, frequency, and number of sticks?
Currently putting together a box for an Alder Lake processor, e.g. an i7-12700k or i9-12900k. I still need to select the memory (RAM) for it.
How can I compare different options to determine which ...
- 1,913
1
vote
0
answers
732
views
MKV file optimization: What does mkclean do exactly?
I have some questions about mkclean... dont know if this the right location to ask, but since i've saw other questions about matroska, mkclean, metadata and similar i'll just ask...
Basically, its the ...
- 121
2
votes
3
answers
4k
views
How long does TRIM take on NVMe SSD / Difference between TRIM applications & Optimize drives
I have set TRIM to be done weekly using the program that is used for WD BLACK SSDs:
This schedule should be fine since I don't really write that often to the drive, and I read that some I/O or OS ...
- 23
1
vote
0
answers
33
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
...
- 111
0
votes
1
answer
33
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 (...
- 115
1
vote
0
answers
59
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
1
answer
97
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
2
answers
139
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 ...
- 11
0
votes
2
answers
221
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
2
answers
12k
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 ...
- 426
1
vote
0
answers
48
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 ...
- 111
1
vote
1
answer
137
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 ...
- 85
1
vote
2
answers
930
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 ...
- 13
0
votes
1
answer
1k
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 ...
66
votes
2
answers
43k
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 ...
- 8,405
2
votes
0
answers
1k
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 ...
- 951
1
vote
2
answers
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 ...
- 123
0
votes
0
answers
93
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-...
- 121
0
votes
1
answer
1k
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 ...
- 615
0
votes
1
answer
405
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,...
- 155
2
votes
1
answer
922
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, ...
- 249
-1
votes
1
answer
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 ...
- 447
1
vote
1
answer
448
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 ...
- 356
3
votes
3
answers
7k
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:...
- 31
2
votes
0
answers
51
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 ...
- 68.3k
0
votes
2
answers
479
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
...
- 237
6
votes
1
answer
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 ...
- 61
0
votes
2
answers
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 ...
- 93
8
votes
5
answers
4k
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 ...
- 14.8k