Questions tagged [optimize]
The optimize tag has no usage guidance.
29
questions
1
vote
0
answers
187
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,963
1
vote
0
answers
1k
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
6k
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
38
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
74
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
129
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
169
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
323
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 ...
- 4,457
1
vote
2
answers
14k
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 ...
- 446
1
vote
0
answers
53
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
139
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
993
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 ...
72
votes
2
answers
50k
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 ...
- 9,014