JavaScript execution exceeded timeout javascript

Question

when I execute this function it displays me the following error:

"JavaScript execution exceeded timeout" how I can solve this problem by using settimeout () or what?

I retrieve 3000 line from json file.

 applyChanges_PhrasesTypes: function(employees, callback) {

            //alert("fonction apply chamges est lancer PhrasesTypes");

          this.db.transaction(
                function(tx) {
                    var l = employees.length;
                    var sql =
                        "INSERT OR REPLACE INTO PhrasesTypes (IdPhrase, IdPhraseES, IdRubrique, IdTypeTravauxAffichage, Phrase, AidePhrase, AvertissementPhrase,OrdrePhrase,QuotationParDefaut,Published) " +
                        "VALUES (?,?,?,?,?,?,?,?,?,?)";
                    //alert('Inserting or Updating in local database:  PhrasesTypes');
                    var e;
                    for (var i = 0; i < l; i++) 
                    {
                        e = employees[i];
                        log(i);
                        //log("Ligne  "+ i +"  est inserer de id PhrasesTypes = "+e.IdPhrase);
                        var params = [e.IdPhrase, e.IdPhraseES, e.IdRubrique, e.IdTypeTravauxAffichage, e.Phrase, e.AidePhrase, e.AvertissementPhrase,e.OrdrePhrase,e.QuotationParDefaut,e.Published];
                        tx.executeSql(sql, params);
                    }
                    log('sync_PhrasesType shronization terminée avec (' + l + ' items sync_PhrasesTypeshronié)');
                },
                this.txErrorHandler_PhrasesTypes,
                function(tx)
                {
                    callback();
                }
            );
        }

@lgor: here is my code but only 2000 insert line, and terminates with an error,

JavaScript execution exceeded timeout javascript

 InsertPortion: function(tx)
    {
     var l = Math.min(gEmployees.length, gIter + 300);

     log('aaaaaaaaaaaaaaaaaaaaaaaa---'+l)

     for (; gIter<l ; gIter++)
                {
         log('do insert here'); 
          var sql =
             "INSERT OR REPLACE INTO PhrasesTypes (IdPhrase, IdPhraseES, IdRubrique, IdTypeTravauxAffichage, Phrase, AidePhrase, AvertissementPhrase,OrdrePhrase,QuotationParDefaut,Published) " +
             "VALUES (?,?,?,?,?,?,?,?,?,?)";
         //alert('Inserting or Updating in local database:  PhrasesTypes');
                var e;            
             e = gEmployees[gIter];
             log(gIter);
             //log("Ligne  "+ i +"  est inserer de id PhrasesTypes = "+e.IdPhrase);
             var params = [e.IdPhrase, e.IdPhraseES, e.IdRubrique, e.IdTypeTravauxAffichage, e.Phrase, e.AidePhrase, e.AvertissementPhrase,e.OrdrePhrase,e.QuotationParDefaut,e.Published];
             tx.executeSql(sql, params);

                  }

                if (gIter < gEmployees.length)
                {
                    log('sync_PhrasesType shronization terminée avec (' + gIter+ ' items sync_PhrasesTypeshronié)');
                    setTimeout(dao3.InsertPortion(tx), 100);
                } 
                else
                {
                   gEmployees = null; 
                   gIter = 0;
                }

   },




applyChanges_PhrasesTypes: function(employees, callback) {

        //alert("fonction apply chamges est lancer PhrasesTypes");

      this.db.transaction(
            function(tx)
            {
                gIter = 0;
                gEmployees = employees;

                dao3.InsertPortion(tx);

            },
            this.txErrorHandler_PhrasesTypes,
            function(tx)
            {
                callback();
            }
        );
    },

I just hope you don't run that SQL stored in JavaScript into a database. Major security issue. — jfrej, Nov 06 '12 at 14:54
@jfrej That could be SQL used on a HTML5 local storage SQLlite database. — Joshua Dwire, Nov 06 '12 at 14:58
@AaminerZeajejk What line is that error occurring on? Also, this can't be the entire code, since `this.db` isn't defined anywhere. Can we have more code? — Joshua Dwire, Nov 06 '12 at 15:00
after having insert 2645 line, the script stops and shows me error message "JavaScript execution exceeded timeout" — Aaminer Zeajejk, Nov 06 '12 at 15:02
If it is taking too long for your javascript to execute in a tight "for" loop, you can split the work into smaller portions, and execute them one at a time triggering these executions using setTimeout. Look up how setTimeout javascript function is used and ask if you need help setting it up. — Igor, Nov 06 '12 at 15:33
@lgor : yes i need help setting it up, and thank you in advance. — Aaminer Zeajejk, Nov 06 '12 at 15:48
Related: [javascript-ios5-javascript-execution-exceeded-timeout](http://stackoverflow.com/questions/7787219/javascript-ios5-javascript-execution-exceeded-timeout) — jfrej, Nov 06 '12 at 15:53
@jlogr: how can i split the work into smaller portions, because { var l = employees.length; } is not fixed — Aaminer Zeajejk, Nov 06 '12 at 16:12

score 0 · Answer 1 · answered Oct 24 '15 at 15:57

0

Consider converting the loops in your code to async calls. Take a look at https://github.com/caolan/async

answered Oct 24 '15 at 15:57

Bulent Vural

2,630
1
13
18

JavaScript execution exceeded timeout javascript

1 Answers1