Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange
Join us in building a kind, collaborative learning community via our updated Code of Conduct.

Questions related to improving application performance, this can be range from selection software architecture to selection of algorithms.

0
votes
1answer
108 views

Simple but frequently throwing vs reasonable but rarely throwing vs complex but never throwing [duplicate]

A lot of code that's designed to convert or parse some data of type Foo into a Bar is written with the assumption that one wouldn't intentionally pass it invalid inputs. As such, it assumes that ...
7
votes
2answers
534 views

How did heavy software in the early days managed to run on 4MB RAM computer? [duplicate]

It's no secret that in the early days of computers, they had only 1-4MB of RAM. I found an article stating you needed only 4MB of RAM to run Word, Excel and PowerPoint simultaneously. How was that ...
1
vote
2answers
346 views

Why should I use foreign keys in database? [closed]

In my 10+ years of experience in the IT field, I have never used foreign keys in any of my project and I never felt the need. I did work with professional databases which had foreign keys constraints. ...
2
votes
2answers
123 views

How do I avoid increased memory consumption by browser and performance degradation when dealing with many records?

In my MVC 5 web application there are many instances in which users will require to view thousands of records within grids, now I managed to get around many performance related issues by utilising the ...
-1
votes
0answers
48 views

benchmarking a large java algorithm

we are developing and maintaining a large java meta-heuristic algorithm. We have build this completely deterministic to make it easy to track bugs or errors. When adding a new feature we are always ...
0
votes
2answers
147 views

High Performance Garbage Collection

I am new to garbage collection but have been looking around. I have noticed that Reference Counting has a very bad reputation (PHP, Python), as well as Conservative GC (Ruby) under certain conditions. ...
0
votes
1answer
100 views

Would Cython-like “Cypescript” be a feasible idea?

Cython is a superset of Python that can be complied into C modules that can be imported and used normally in Python code. This can be used to speed up parts of a Python program. In a recent project, I ...
-1
votes
1answer
30 views

Tolerated Performance when generating a document from SQL

Is it acceptable for a framework to generate an XLS document of more than 300k rows and 6 columns in 2 minutes? This framework took 2 minutes to generate the document while fetching data from a local ...
2
votes
1answer
213 views

ToList() vs Using default list constructor

After reading rules of Clean Code, one of them is to use default constructor when using transferring data from one collection to other. For example i have : Dictionary<string, string> dict = ...
3
votes
1answer
183 views

Are design principles of functional programming languages and current hardware (register-machines) contrary?

Functional languages seek to minimize accidental state (computationally-convenient but logically unnecessary data dependencies) by endorsing the most granularly modular, mathematically unambiguous ...
0
votes
1answer
44 views

How to load test Publisher/Subscribing queue?

I am trying to load test a queue that works on a pub sub pattern and can't figure out how response time is to be calculate and the TPS(transactions per second). Problem statement : The pub sub ...
2
votes
1answer
140 views

Is it a good idea to release an application with custom performance counters?

I have been reading on C# Performance Counters and I was wondering if I should be keeping them in my release build? I have never encountered an application that has it's own custom performance ...
-1
votes
1answer
21 views

Cursor select on 2nd Primary key on db2 sql field for embedded positional value - Unable to determine most efficient for longterm design

I have a SQL DB2 table where the first two fields are the primary keys (not including the third field which is date/time stamp). The table was designed by another team with the intent to make it ...
-2
votes
1answer
111 views

Avoiding multiple calls to SQL and persist data

I often received messages objects and for each of them I need to query the database in order to achieve some additional information from one database table. Since we are performing many requests to ...
0
votes
2answers
114 views

Exponential Growth of Scope of C++ Projects

I've been coding in C++ professionally for six odd years, and it's my go-to language for performance-critical projects. When working to a deadline, the scope expands to fill the time available. ...
0
votes
2answers
113 views

Improvements in java based test framework to reduce execution time

Let me give a bit of background on the problem. We have a java application which has MQ integration and an Integration Test pack which is also written in java. The test pack runs all scenarios (...
1
vote
1answer
194 views

Why is one way data flow (eg. React, Vue, Angular) faster than two way data binding with dirty checking?

I understand that two way data binding can be expensive and slow. For example, imagine a toy grocery list app that lets you list grocery items and their prices, and shows you the sum of the prices (...
8
votes
3answers
1k views

Reasons behind non-intuitive C# String.Split() implementation

In C# if I want to split a string by another string I have to do something like that : testString.Split(new string[] { "anotherString" }, StringSplitOptions.None); From the overloaded String.Split ...
0
votes
0answers
62 views

Best way to reduce memory consumption on persisting Java objects

Let's say I have an application that maintains relationships between objects - think of a parent-child relationship tree. The lineage of these objects are critical, so maintaining references from ...
1
vote
1answer
76 views

How can I model unknown and an unknown number of attributes on an object?

My example might be slightly contrived, because I've modified it so that the project isn't recognizable by my employer. I'm a newer developer at a very small company. We have an object - Posts - that ...
0
votes
3answers
248 views

Global state variables vs constructor parameter passing

A couple of readonly variables will be used. Almost all of the classes will be using those variables. Either I place all of the variables in a separate internal static class or I pass them on ...
0
votes
0answers
16 views

Better Approach for Expanded RecylerView

I want to make below-mentioned expanding Layout inside RecylerView. This is how it looks when it is not expanded. You can find the source code of Expandable RecyclerView in my GitHub repo here. Now ...
-2
votes
1answer
35 views

pixels aside, how to cross the uncanny valley of hybrid apps? (performance)

I see the top drawbacks of hybrid (webview/dom) apps, compared to native, as the following, in order time to startup/launch smooth frame rates (no jank) responsiveness to input, instantaneous are ...
1
vote
1answer
183 views

Chat application - write to file and then save in database

I have followed this approach that is described here to implement a simple chat application: https://code.tutsplus.com/tutorials/how-to-create-a-simple-web-based-chat-application--net-5931 I'm ...
0
votes
1answer
31 views

Assembling random indexed packages into an ordered sequence(s)?

I am pretty confident that this is well-known and solved problem. Suppose there are n uniquely indexed "packages" randomly getting into single entry point like .AcceptPackage(Package package). ...
2
votes
2answers
195 views

Reading huge (up to 32 GB) file in multithreading env?

Goal: 1) huge file read in chunks each 1 MB long, 2) each one gets compressed and written to an another output file. Note: I am limited to .Net 3.5 only. Is there a known pattern how to parallelize ...
4
votes
3answers
173 views

Optimal Immutable Data Structure for Highly Dynamic Particle System

Trying to see if immutability is a good fit for highly dynamic objects like game entities (that constantly are moving around and changing) or particle systems, each which might have thousands or ...
2
votes
4answers
287 views

Designing database for a table with huge number of rows

Suppose, I am developing an application to keep track of daily sales of of a small retail shop of only three employees. Suppose, the owner agrees to buy only one PC, and, refuses to purchase a copy ...
1
vote
1answer
122 views

What tools exist to determine the speed up a GPU will have on an algorithm?

Basically, I am wondering what sort of speed I will get by parallelizing a algorithm to work with GPUs. I am wondering if someone has implemented queueing theory/Amdahl's law with a UI or if everyone ...
0
votes
3answers
68 views

Performance on highly filterable web pages

In our application we have a page were we list our entities with many options to filter and to search. Over time this page got slower and slower especially for large datasets, so we thought about how ...
-7
votes
1answer
109 views

Writing tool to make large number of http requests with sub second accuracy

I'm pondering a project in which one component needs to make a large number of http requests at accurate times. It should, let's say, release a set of 'dozens to hundreds' of requests at 1 second ...
1
vote
1answer
87 views

Direction to take to improve a AST interpreter

I'm looking for some opinions/advices about a particular subject. Here is the situation : I'm developing for fun, in my spare time, a programming language interpreter made in C# and I'm looking for ...
1
vote
0answers
99 views

How to Investigate the difference between query execution times?

I have a simple query, when executed directly in SQL Developer Studio (It's an Oracle Database) takes around 4 seconds. But when executed via my Java code it takes around 20 seconds. I'm using ...
3
votes
5answers
361 views

Is there a practical benefit to using the smallest datatype possible?

In C# (and other languages), we can define a numerical variable as a short, an int, or a long (among other types), mostly depending on how big we expect the numbers to get. Many mathematical ...
1
vote
1answer
137 views

System Design: Chat Application and Polling

What would be the best way to add chat feature to an android, ios, and web app? Is polling really as bad as people say? The requirements are user to user messaging and chat rooms. Here is my thought ...
0
votes
0answers
107 views

Scoped beans as dependencies - Use proxy or make it dependent/prototype scoped?

Regarding overall performance, when used as a dependency of a higher scoped bean, is it better to downgrade a bean scope to prototype or dependent instead of using proxies? Consider a scenario where ...
-5
votes
1answer
140 views

What is faster, to read 100MB from file or to compile 100MB of code?

I want to generate a test scene for a unit-test (big file parser). What will be faster, to have a test file and to perform I/O on it, or to generate a large memory buffer using some static parameters ...
0
votes
0answers
33 views

Mobile app background service continuous web request impact on battery

I want to create a cross-platform app (UWP, Android, iOS) where the app would be making multiple requests to different addresses in certain intervals in the background. The number of requests is ...
16
votes
8answers
978 views

When is it better to optimize a software for better performance, at the beginning or at the end of the development?

I'm a junior software developer and I was wondering when would be the best time to optimize a software for better performance (speed). Assuming the software is not extremely large and complex to ...
0
votes
0answers
44 views

Background Network Listener for mobile Notification System (architecture and performance )

I'm currently designing an application on the Android platform, and i need to implement a background service (for notifications ) that will run as long as the device is on but i don't know if the ...
2
votes
1answer
51 views

Is there a limit of requests that an Apache server can make and wait for response?

Let say I have an Apache server that needs data from external API before serving the page. I wonder if there is a limit of requests an Apache server can make and wait for response. Or does it depend ...
3
votes
2answers
131 views

Does prefetch data by Apache before serving a SPA site hurt performance?

I have this application containing 2 parts: User-facing SPA web served by Apache NodeJS API server When a user go to the SPA web, Apache will do authentication and prefetch data for that user by ...
-1
votes
1answer
36 views

Measure ActiveRecord performance in `limit` method [closed]

How can I measure ActiveRecord's performance? My query has where and an order by clause, and on top of that I want the top row: User.where(…).order(id: :asc).limit(1) Knowing that the order by ...
4
votes
1answer
169 views

Massive Simulator Software Architecture [closed]

I am looking to perform a large overhaul on a complex simulation system that simulates several instances of several vehicle models in a classroom training environment. For example, 24 students may be ...
1
vote
1answer
192 views

Is comparing “dollar-hours” for running a specific piece of code practical as an estimate of rented system performance?

Background: there'a a gazillion types of virtual machines in Microsoft Azure each having different performance and price. Such virtual machines are paid per hour. The goal is to decide how to get "the ...
0
votes
1answer
37 views

Efficiently broadcast user status

This turned out to be a rather interesting problem contrary to my expectations. Imagine a simple chat app, a user registers then can add other users to their contacts list and start conversations. I ...
6
votes
1answer
283 views

Handle Optional Logging in High-Performance Library

I'm writing a library in C++ which needs to be as fast as reasonably possible. However, I'd also like to be able to provide logging in case a user (or me) needs to debug possible problems. This ...
0
votes
1answer
44 views

Performant way for archiving image files in NodeJS on each user requests

Scenario: Images are uploaded to the server once in a while. Users send an API request for downloading all of those images that were uploaded to the server (Images reside in the server itself). ...
0
votes
0answers
40 views

Location specific caching for read-heavy data (server architecture)

This project will serve many duplicate requests with location-specific answers. I.e. 10,000 people in New York will all get the same server response (a list of businesses in New York), but one person ...
-3
votes
1answer
63 views

Web-Application with file generation pattern

I work on a java web-application. In this application, users can generate some reporting (xls/pdf) and create some pack of multiple reporting. (using pdfbox, itext) More and more data are added in ...