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…
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…
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…
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…
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…