Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

Web and WebWorks Development

Reply
Developer
Posts: 84
Registered: ‎06-26-2008
My Device: Not Specified

Re: widget gears database throughput

I tested the app with an older SD card that comes with the BB8310 with 1GB instead of 2.

 

It's too much faster, it takes 16 seconds to insert 100 files into DB... but i still think it should be faster, shouldn't it?

 

1739i187D048D82865076

Developer
Posts: 84
Registered: ‎06-26-2008
My Device: Not Specified

Re: widget gears database throughput

I was reading about SQLLite and i read that it's an auto-commit database like those we use on our computers and servers... so the time with the Scandisk 1GB SD card that comes with the BB 8310 should not be considerated as slowly.

 

I create a begin / commit block on my code

 

//

db.execute("begin",null);
    for (var i=0;i<size;i++){        
        db.execute("insert into Sample values (?,?)", [""+i, "texto for line " +i]);        
    }

db.execute("commit",null);
   

 

the time comes down to 4 seconds with scandisk 1GB SD, and 6 with the poor 2gb sd card that comes with the Bold 2.

 

1758i0322E1F1CF2D55AC

 

So, don't forget to use transaction with SQL Lite if you want a fast application.

 

Enrique.