Erel,
just wanted to touch base with you again. The program has no issue with the .bal file size.
I removed all and I was still over 15 seconds so I returned to original and started removing
items 1 at a time in the activity create.
Turns out I had forgotten that the MFG table was so huge (almost 2600 records).
The lag it turns out was in the loop all records to add MFG (if not exist already) to the spinner.
'Get MFGNames to spinner
SQL1.Initialize(DBFilePath, DBFilename, False)
Cursor1 = SQL1.ExecQuery("SELECT MFG FROM BC2015 order by MFG Asc")
'Get last calculation values
If Cursor1.RowCount<>0 Then
For i = 0 To Cursor1.RowCount - 1
Cursor1.Position=i
MFGNAME=Cursor1.GetString("MFG") 'first item to spinner
If MFGNAMESAVED="" Then
Spinner1.add(MFGNAME)
MFGNAMESAVED=MFGNAME
End If
If MFGNAMESAVED<>"" Then 'all other items
If MFGNAME<>MFGNAMESAVED Then
Spinner1.Add (MFGNAME)
MFGNAMESAVED=MFGNAME
End If
End If
Next
End If
Cursor1.Close
Catch
Msgbox(LastException,"ERROR")
End Try
I am now back to a 4 sec load, trying to figure out how to speed that operation up.