Questions tagged [code-maintainability]
66 questions
1
vote
1 answer
What is the best way to fix a Oracle Query performance in production? Changing application code? Using plan baseline?
Let's assume there is a C++ application executing a specific SQL query on Oracle database.
This query was working fine for last couple of years in production at a customer's environment, but suddenly one fine day the query started taking around 10x…

Jackie
- 11
- 1
1
vote
1 answer
Several TextViews or Concatenated Strings?
Approach 1: In an android app there is shown a duration TextView (like: "2 h 45 m") and another TextView with number of Stops (like: "Stops: 15"). Between them is another TextView (" | ") to separate them.
Approach 2: using only one TextView, a…

David
- 173
- 12
1
vote
2 answers
update with many common sub-expressions
What is the best way to calculate a table where many columns are calculated from other columns in the same table and the formulas build on each other in complex ways.
If you don't care about performance, you could simply calculate each column with…

cypres
- 31
- 3
1
vote
2 answers
What is a better way to change variable in runtime server?
We maintain our server once a week.
Sometimes, the customer wishes that we change some settings which is already cached in server.
My colleague always write some JSP code to change these settings which are stored in the memory.
Is it a good method…

Cheng
- 316
- 3
- 9
1
vote
1 answer
How Android Product Flavors and Configuration help to maintain and support single code base to distribute multiple client
I have a requirement Android Product Flavors and Configuration help to maintain and support single code base to distribute multiple clients.
I referred few links, It gives a basic idea. My question is actually Am I'm going correct direction. I…

MohanRaj S
- 1,958
- 4
- 30
- 54
1
vote
2 answers
How should I manage too many TCL procedures?
Me and my team have been working on multiple tools flow for awhile now.
We keep adding new procedure in either a same file or creating new file in the same directory. There are also a lot of nested procedures; one calls others.
The number of…

Minh Le
- 23
- 3
1
vote
4 answers
How much performance do I lose by increasing the number of trips to SQL Server?
I have a web application where the web server and SQL Server 2008 database sit on different boxes in the same server farm.
If I take a monolithic stored procedure and break it up into several smaller stored procs, thus making the client code…

Ben McCormack
- 32,086
- 48
- 148
- 223
1
vote
1 answer
Events in Object variables
Can you place a jQuery event inside of an object variable like so:
var taskObj = {
buttonClick:function() {
$("#button").click(function() {
alert("Something");
)};
}
}
If so how would you call it the method?…

Joe Kasavage
- 503
- 5
- 13
1
vote
2 answers
Adding tombstones in python
EDIT: Apparently what I'm talking about is not called a tombstone. I got that term from this video: https://www.youtube.com/watch?v=29UXzfQWOhQ
I'm working on a complex django webapp, and recently I started to think about adding tombstones to detect…

megapctr
- 931
- 1
- 7
- 19
1
vote
1 answer
Is concatenating classes good practice?
Why do I see .closed-dialogue and .open-dialogue so often in commonly-used libraries, instead of .closed.dialogue and .open.dialogue?
the problem with a single class per element
To format all dialogues with the first approach, you would already need…

Andy
- 4,783
- 2
- 26
- 51
0
votes
0 answers
How do I ensure that the correct job bookmark is being applied to the correct job when passing different job parameters to the same job in AWS Glue?
I am utilizing AWS Glue jobs and want to utilize the job bookmarking feature. Right now, I checked the 'enable job bookmarking' box within AWS. However, I use the same Glue job when passing different input parameters for the job to run on different…

Nick Wawee
- 1
- 2
0
votes
1 answer
Should We Centralise the components in ReactJs?
I have a question.
I am making a react-application for a major industry, which contains a huge number of components.
But I have found that most of my components utilised the same functionalities . For eg, I am making use of Material Ui as my UI…

Himanshu Sharma
- 315
- 2
- 9
0
votes
0 answers
Code refactoring seems to be a necessary evil. How can one make it less painful?
I was working on a project that involved refactoring a large codebase that had been in development for several years. One of the difficulties I encountered was that the codebase was very complex and had a lot of interdependent components, which made…
0
votes
1 answer
Create a dashboard with reports in Laravel API
I am working on a Laravel API project, and I am trying to build a dashboard with four simple reports. The reports get the data from different (already existing) models. So I was wondering where I should create the queries for those reports. Should I…

Elisaveta
- 39
- 5
0
votes
1 answer
Where domain logic should go when there is no aggregate?
Short question.
From DDD perspective (or just maintainable architecture and common sense), where should I put a layer of business logic that has no domain objects to operate with but does some "smart" data preparation and orchestrate a bunch of…

shumantt
- 23
- 5