mORMot Open Source

Victor Zanella

Member

From: Santa Catarina

Registered: 2014-10-10

Posts: 9

Execute a dumpedfile

I have a dumpedfile, and now i have to execute it.
So i made a loop, that execute line by line.

I have a 150mb database, and it gives me a large dumpedfile, and if i made this loop, it take over 30 minutes.
When i execute this dumpedfile trough Sqlite3.exe, it take 10 seconds.

So, i want to know if is there's a way to execute more that one command per execute.

Something like this:

Props.ExecuteNoResult(RawUTF8('Begin transaction; Create table Blabla; Insert into blabla values (blabla ... ; Commit;'), []);

Victor Zanella

Member

From: Santa Catarina

Registered: 2014-10-10

Posts: 9

Re: Execute a dumpedfile

I solved my problem, but now seems like ExecuteNoResult, can't execute a lot of commands quickly.

If i put a sleep(1), it works well, but still take 1-2 minutes.

PS: I'm still executing line by line.

Edit1: My file have 220000 lines, and it's 220000 milisseconds stopped. If i take this sleep off, i get an access violation from Execute command.

Last edited by Victor Zanella (2015-09-10 14:23:15)