I'm making an app need to do only queries on a database. As this is a very large amount of data, I think it would be counterproductive to feed this database using an insertOrThrow for each item in a table. I do not know the best way to do this, so I'm doing a "blind" procedure here, but it's not being very effective. To insert this data I used the SqliteStudio utility. Anyone there ever done such an operation? Which database manager do you suggest for use? I'm having trouble importing this manager-generated database into the Android Studio project. From what I've researched, you need to create a folder named Assets in the project and put the database in there.
On the import, I found information to use the InputStream class, but I could not load the file information. During execution, in the procedure to list the data, it enters cath and says that no table was found in the database. The biggest goal of this question is to get advice on how to perform a bulk data insertion operation on a database and use it for browsing through Android Studio. Anyone who can contribute, thank you. Thank you!