Tips for minimizing database queries for each data type

Question

Tips for minimizing database queries for each data type

I'm currently developing an App that requires the user to input numbers into two different fields. The first field is for entering numbers, while the second field displays a calculation based on the input. Each time the user enters a number, a call to the database is made, and I'd like to minimize these calls. Ideally, I want to give the user some time to enter the input before making the database call.

Below is the function defined in a service:

applyStraightRisk = function(slip, amount) {
      applyStraightRiskWin({
        wagerType: '1',
        riskOrWin: 'RISK',
        riskValue: amount,
        winValue: slip.win || 0,
        amount: amount,
        selections: [slip]
      });
    }, applyStraightWin = function(slip, amount) {
      applyStraightRiskWin({
        wagerType: '1',
        riskOrWin: 'WIN',
        riskValue: slip.risk,
        winValue: amount,
        amount: amount,
        selections: [slip]
      });
    }

return {
  riskWinCalculations: function(params, scope, index) {
    switch (params.type) {
      case 'RISKSTRAIGHT':
        applyStraightRisk(params.slip, params.slip.risk);
        break;
      case 'WINSTRAIGHT':
        applyStraightWin(params.slip, params.slip.win);
        break;
  };
}

One option I was considering was using $timeout/setTimeout but I wonder if there is a more effective approach?

javascript

Answer 1

Answer №1

If you want to add a delay to your function, you can utilize the 'debounce' feature from the underscore.js library.

    applyDelayedFunction = _.debounce(function(param1, param2) {
    ...
    }, 500); // Function will only run once every 500 milliseconds

If you prefer to use this function independently (source: underscore.js)

_.debounce = function(func, wait, immediate) {
  var timeout, args, context, timestamp, result;

  var later = function() {
    var last = _.now() - timestamp;

    if (last < wait && last >= 0) {
      timeout = setTimeout(later, wait - last);
    } else {
      timeout = null;
      if (!immediate) {
        result = func.apply(context, args);
        if (!timeout) context = args = null;
      }
    }
  };

  return function() {
    context = this;
    args = arguments;
    timestamp = _.now();
    var callNow = immediate && !timeout;
    if (!timeout) timeout = setTimeout(later, wait);
    if (callNow) {
      result = func.apply(context, args);
      context = args = null;
    }

    return result;
  };
};

This method involves using setTimeout for timing control.

Answer 2

If you want to add a delay to your function, you can utilize the 'debounce' feature from the underscore.js library.

    applyDelayedFunction = _.debounce(function(param1, param2) {
    ...
    }, 500); // Function will only run once every 500 milliseconds

If you prefer to use this function independently (source: underscore.js)

_.debounce = function(func, wait, immediate) {
  var timeout, args, context, timestamp, result;

  var later = function() {
    var last = _.now() - timestamp;

    if (last < wait && last >= 0) {
      timeout = setTimeout(later, wait - last);
    } else {
      timeout = null;
      if (!immediate) {
        result = func.apply(context, args);
        if (!timeout) context = args = null;
      }
    }
  };

  return function() {
    context = this;
    args = arguments;
    timestamp = _.now();
    var callNow = immediate && !timeout;
    if (!timeout) timeout = setTimeout(later, wait);
    if (callNow) {
      result = func.apply(context, args);
      context = args = null;
    }

    return result;
  };
};

This method involves using setTimeout for timing control.

Tips for minimizing database queries for each data type

Answer №1

Similar questions

What is the best way to halt a specific function in jQuery?

How can I add color to arrow icons in tabulator group rows?

When transitioning to an object, Vue.js fails to refresh

Assign a unique HTML attribute to a child element within a Material-UI component

Adding Node Modules during the setup of an ElectronJS application

Obtain every possible sequence of US phone number segments for a provided number

Executing actions on events in a Basic jQuery sliderLearn how to handle events and execute

Is there a way to utilize the 'interval' Rxjs function without triggering the Change Detection routine?

The download functionality in HTML5 is not functioning properly, so users are forced to rename files when downloading

Background image not displaying in new tab after Chrome extension installation

Looking to add some movement to your website? Learn how to make an image track your mouse pointer in a specific section of your webpage

Tips for extracting unique values from two arrays and returning them in a new array using JavaScript

When was Chrome first updated to include timezone offset support for Intl.DateTimeFormat()?

When using React.js with Leaflet, ensure that the useEffect hook is only run on Mount when in the

Duplicate values of React object properties when using .push method within a loop

Creating a private variable to perform a select_sum query

Is there a way to postpone the execution of a scheduled interval function?

Calculating remaining change with the modulus operator in JavaScript

Stop the execution of javascript code based on the screen width

Prevent text from wrapping when using jQuery to animate font size