Skip to content

Slow run #568

Open
Open
@ghost

Description

Hi,
I'm in the process of developing a census surveillance system using SQLite storage in React Native. However, I'm encountering a performance issue. Initially, when I log in for the first time, everything is quick, and generating 40 rows of records on the screen works fine. The problem arises when I log out and attempt to log in multiple times to check the system – it becomes progressively slower. After a couple of attempts, loading just 40 records takes more than 40 seconds. The slowdown starts from the third attempt.

DOES ANYONE HAVE A SOLUTION TO THIS ISSUE? Any advice or assistance would be greatly appreciated.

even this below function
db.transaction(
function(tx){
tx.executeSql(
"select * from user where userID='"+userID+"' and password = '"+userPass+"'",
[],
function(tx, result){

  var lengt = result.rows.length, i;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions