Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Slow run #568

Open
nehalasim opened this issue Jan 5, 2024 · 0 comments
Open

Slow run #568

nehalasim opened this issue Jan 5, 2024 · 0 comments

Comments

@nehalasim
Copy link

nehalasim commented Jan 5, 2024

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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant