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

casperjs is encountering difficulty locating the id even after setting it

The process of AJAX polling a JSON-returning URL using jQuery's $.ajax() method does not appear to provide up-to-date responses

When attempting to click on the dropdown in Bootstrap, there is no content displayed

Vanilla JavaScript code that utilizes regex to transform JSON data into an array of blocks, while disregarding any

Assigning a new classification to the primary object in the evolving array of objects

Rendering a Nativescript component once the page has been fully loaded

Enhance the functionality of the Bootstrap navbar by enabling the slideUp and slideDown effects

Tokenizer method utilizing strings

Utilizing Ajax to send IP addresses and obtain location data

The request for the specified URL is incorrect

Issue with Photoswipe pswp class Not Getting Properly Cleared Upon Closing Image

Recording audio using Cordova and Javascript

The functionality of Jquery AJAX is operational, however, the message being displayed appears to

Await that's locked within a solo asynchronous function

Error: THREE.MTLLoader is not a constructor, version 3.0 bug uncovered

Guide on adding JSON data from a web service whenever a function is invoked in AngularJS

Remembering previous scroll position with jScroll upon revisiting page

Is it possible to customize the close icons on the autocomplete feature in Material UI?

EJS forEach method not displaying output

Using PHP variables in JavaScript fetched through AJAX loading