now question is how can I run query only and only ...

# android

[Ramin]

now question is how can I run query only and only when I make sure copy operation get completed

[Dominaezzz]

Unless you have a multi-threaded application, that's probably not the issue. You might not be copying the database properly.

[Ramin]

in the second run application works fine

[Ramin]

so it means copying db is ok because I check for file if exist not copy

[Dominaezzz]

And you don't copy it in another thread or IntentService?

[Ramin]

val outputStream = FileOutputStream(dbDestinationPath)
assetManager.open(DB_NAME).use { input ->
outputStream.use { output ->
input.copyTo(output)
}
}

I use this to copy dont think run in another thread Im quite new in kotlin and android

[Ramin]

the only thing I was suspicious was running on two thread but it seems as you mentioned its not multi thread so what can be the issue

[Dominaezzz]

Where is that code in? An Activity? Fragment? Service? OR the SQLiteOpenHelper?

[Ramin]

SQLiteOpenHelper

[Ramin]

I will call it in onCreate method in helper class

[Ramin]

DatabaseOpenHelper.kt

DatabaseOpenHelper.kt

[Dominaezzz]

Weird, that should be fine.

[Dominaezzz]

Unless, you have multiple instances of it?

[Ramin]

in home fragment I use this

[Ramin]

private val Context.database: DatabaseOpenHelper
get() = DatabaseOpenHelper.getInstance(applicationContext)

[Ramin]

in other freagment I have same code I know its better to put them in a parent class and extend from it but those fragment/activities shouldnt be the problem

[Dominaezzz]

Comment out line 38 and 45, and see if it works on first run.

[Ramin]

ok

[Ramin]

no same issue

[Ramin]

Dominic

[Dominaezzz]

Oh, then I'm not sure what could be wrong.

[Ramin]

@Dominaezzz apart from this I have question I have 250K rows is there any solution to make sqlite query faster

[Ramin]

I put index on column and use VACUM

[Ramin]

but still its not fast enought

[Ramin]

rxkotlin or any other approach

[Ramin]

I will go through them and learn them just need to know if there is a technology to make a better user experience and dont lag when typing

[Dominaezzz]

Trying doing the copy in an init block instead of onCreate().

[Dominaezzz]

Sqlite should be pretty fast with 250k rows.

[Ramin]

I will run the query when tryping

[Ramin]

searchView.setOnQueryTextListener(object : SearchView.OnQueryTextListener {
override fun onQueryTextSubmit(s: String): Boolean {
updateUI(s)
return true
}

override fun onQueryTextChange(s: String): Boolean {
updateUI(s)
return true
}
})

[Ramin]

in updateUI() method

[Dominaezzz]

Use Room with LiveData. That'll take work off the UI thread.

[Ramin]

hmmm thanks