Search the Community
Showing results for tags 'Efficiency of code'.
Found 1 result
-
Local $query = "(Select COUNT (*) From Files)" $adoRs.Open($query, $adoCon) $Parray = $adoRs.GetRows() $adoRs.Close Local $iRows_id = $Parray[0][0] _GUICtrlListView_DeleteAllItems($listview_Files) If $iRows_id <> 0 Then For $i = 1 To $iRows_id Local $query = "(Select * From Files)" $adoRs.Open($query, $adoCon) $Parray = $adoRs.GetRows() GUICtrlCreateListViewItem($Parray[$i - 1][1] & "|" & $Parray[$i - 1][2] & "|" & $Parray[$i - 1][3] & "|" & $Parray[$i - 1][4] & "|" & $Parray[$i - 1][5] & "|" & $Parray[$i - 1][6] & "|" & $Parray[$i - 1][7], $listview_Files) $adoRs.Close Next EndIf Hi, Please can someone have a look at my code to see if is efficient to work with large number of records, either at the database query part or GUICtrlCreateListViewItem part. I have uploaded part of the code which I think may be inefficient. Would be grateful for any suggestions. Regards, Ajit
