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){
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){