B4J Question Too many loops making layout stop updating?

javieret

New Member
Hello everybody! Well, i have this problem. I'm writting an app which parses text and writes the results in a sqlite db. It's full of loops which is, i think, the cause of my problem: the layout stops updating until the processes are over, not even a progressbar with its progress property set to -1 updates on screen. Can you think of a solution?
 

javieret

New Member
Hi Erel! Regarding (1) it made no difference; regarding (2): I tried it and now it runs faster than light! Really, thank you!
Sidenote: i had a problem when trying to use transactions using sqlite syntax ("BEGIN TRANSACTION;... COMMIT TRANSACTION; ", as it wrote nothing into the db. Instead, using B4J SQL.BEGINTRANSACTION... SQL.TRANSACTIONSUCCESFULL did the trick. I guess i will start a new thread about that. Thanks again!
 
Upvote 0

Harris

Expert
Licensed User
Longtime User
Hello everybody! Well, i have this problem. I'm writting an app which parses text and writes the results in a sqlite db. It's full of loops which is, i think, the cause of my problem: the layout stops updating until the processes are over, not even a progressbar with its progress property set to -1 updates on screen. Can you think of a solution?
Provide code block example. I have hit this wall before as well. As Erel stated, make sure you use transactions or you will kill performance. This is one of the first things he taught me so many years ago (and had to remind me many times - because of my CRS problem (can't remember shit))... Thank god these posts remember!
 
Upvote 0
Top