Android Question v3 BETA #3 sql performance issue in rapid debug

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 2, 2013

• #2

SQL execution is the same speed. I guess that in LoadSQLiteDB you are creating many rows. You can pause the execution to see where it spends most of the time.

 

Upvote 0

A

Alwinl

Member

Licensed User

Longtime User

• Oct 2, 2013

• #3

Like I say, it's only 9 rows and it was fine before - something is way slower with the new rapid debug.

I agree that the SQL execution is not the problem but it seems that all the routines internal to the Table object that use loops, are slow (I doubt it's specific to the Table object)

eg. in Table.innerClearAll, the loop below takes forever (it is a nested loop, not sure if that's a factor)

For i = 1 To 80 'fill the cache to avoid delay on the first touch
LabelsCache.Add(CreateNewLabels)
Next

Perhaps the Table author can verify what I'm seeing

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 3, 2013

• #4

The Table creates an internal cache when it is created. Testing it with beta #4 it takes 2-3 seconds to create a Table and add 50 rows. Are you testing it with a real device or the emulator?

 

Upvote 0

A

Alwinl

Member

Licensed User

Longtime User

• Oct 3, 2013

• #5

I am using a real device, the slowdown I experience is with beta#3 - I downloaded the link right now but still seem to have beta#3, is beta#4 available for download?

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 3, 2013

• #6

Will be available later today. Can you upload your project (File - Export as zip)?

 

Upvote 0

A

Alwinl

Member

Licensed User

Longtime User

• Oct 3, 2013

• #7

It's the same project I uploaded earlier but now this problem depends on data which come from a backend system. I'll try knock up a test app that shows the issue.

 

Upvote 0

A

Alwinl

Member

Licensed User

Longtime User

• Oct 3, 2013

• #8

Ok, here's the test app. Using legacy debug the table populates quickly, with rapid debug it is very slow.

 

Attachments

• perftest.zip

  22.7 KB · Views: 267

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 3, 2013

• #9

Clearing the table class is a heavy operation. In your code you are clearing it twice as LoadSQLiteDB clears it again.

With this code, tested with beta #5 (which is not yet available) it takes 8 seconds to load.

B4X:

Sub btnRun_Click
   ProgressDialogShow("Running")
   Try
     Dim s As Long = DateTime.Now
     tbl.LoadSQLiteDB(sql1, "select * from data", True)
     Log(DateTime.Now - s)
   Catch
     ProgressDialogHide
     Msgbox(LastException.Message, "Error")
   End Try
   ProgressDialogHide
End Sub

It was helpful as there was an optimization that was not working properly. This is fixed for beta #5

The rapid debugger is slower compared to standard execution. There are cases where you should use the legacy debugger instead.
With that said I'm sure that with future versions of Basic4android it will become faster...

 

Upvote 0

A

Alwinl

Member

Licensed User

Longtime User

• Oct 3, 2013

• #10

Thanks Erel, I expected the rapid debug to be slower then legacy but not to an order of 30 times

I'm sure the optimizations are the bit I need.

 

Upvote 0