Android Question SQlite large query from file

hub73 · Mar 27, 2016

Hi !

I'm searching a way to execute INSERT big query inside my SQLite database.

As i have a lot of items, could i 'load' the query from a text file ? So could you help me with the syntax...

It's a nightmare to edit the query inside the IDE. (it was a Mysql query)

Dim Query as String

Query = " " & <--- data from the file.txt --> & " "

and my file.txt :

insert into t_big_table values ( ... a lot of ...)

Many thanks

KMatle · Mar 27, 2016

As far as I know there is no command line in Android (like in MySQL to do some stuff). So a simple load will not do.

What you can do is to speed up the inserts like this: http://stackoverflow.com/questions/...multiple-rows-at-a-time-in-an-sqlite-database

Just read the file with the values to insert (export it from MySQL as a .csv file so you can just read from it)

Erel · Mar 27, 2016

Make sure to explicitly create a transaction. The inserts will be much slower without it.

mc73 · Mar 28, 2016

If your query's syntax is compatible with sqlite (I see few reasons why it's not), then you can just begin a transaction (as Erel previously suggested) and then execute a nonQuery containing the file.readString(your query's txt file). If for some reason your query is not exactly suitable for such action, you can always split your txt file into many rows and pass them to sqlite using a loop.

hub73 · Mar 29, 2016

Many thanks !

Android Question SQlite large query from file

hub73

Active Member

KMatle

Expert

Erel

B4X founder

mc73

Well-Known Member

hub73

Active Member

Similar Threads

Android Question SQlite large query from file

hub73

Active Member

KMatle

Expert

Erel

B4X founder

mc73

Well-Known Member

hub73

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency