-Ïîèñê ïî äíåâíèêó

Ïîèñê ñîîáùåíèé â rss_sql_ru_access_programming

 -Ïîäïèñêà ïî e-mail

 

 -Ïîñòîÿííûå ÷èòàòåëè

 -Ñòàòèñòèêà

Ñòàòèñòèêà LiveInternet.ru: ïîêàçàíî êîëè÷åñòâî õèòîâ è ïîñåòèòåëåé
Ñîçäàí: 16.03.2006
Çàïèñåé:
Êîììåíòàðèåâ:
Íàïèñàíî: 4


Èçìåðèòü âðåìÿ âûâîäà äàííûõ íà ôîðìå, èñïîëüçóÿ òàéìåð è Recordset

Âîñêðåñåíüå, 28 Äåêàáðÿ 2014 ã. 17:17 + â öèòàòíèê
Çäðàâñòâóéòå. Ïîìîãèòå, ïîæàëóéñòà, ðåàëèçîâàòü ñëåäóþùåå.

Íåîáõîäèìî, ïåðåìåùàÿñü ïî çàïèñÿì â ôîðìå (ñ ïîìîùüþ Recordset), ïîëó÷èòü, êàêîå âðåìÿ çàíèìàåò âûâîä âñåõ äàííûõ â ýòîé ôîðìå.

Ó ìåíÿ ñåé÷àñ îáðàáîò÷èê ôîðìû âîò òàê âûãëÿäèò. ß èçìåðÿþ âðåìÿ çàãðóçêè èçîáðàæåíèé â ôîðìó ñ ïîìîùüþ ôóíêöèè timeGetTime(). È ïîëó÷àþ âðåìÿ âûïîëíåíèÿ êîäà äëÿ êàæäîé çàïèñè îòäåëüíî.

Private Declare Function timeGetTime Lib "winmm.dll" () As Long
Private Sub Form_Current()
    ' Åñëè äëÿ çàïèñè òåêóùåãî ñîòðóäíèêà èìååòñÿ ôîòîãðàôèÿ,
    ' îíà îòîáðàæàåòñÿ â ôîðìå. Åñëè óêàçàííûé ôàéë íå ñóùåñòâóåò,
    ' ëèáî åñëè äëÿ òåêóùåãî ñîòðóäíèêà ïîëå èìåíè ôàéëà ïóñòî,
    ' íàäïèñü errormsg âûâîäèò ñîîòâåòñòâóþùåå ñîîáùåíèå.
    Dim res As Boolean
    Dim fName As String
    Dim t As Long
    t = timeGetTime()
    path = CurrentProject.path
    On Error Resume Next
        ErrorMsg.Visible = False
        If Not IsNull(Me![Ôîòîãðàôèÿ]) Then
            res = IsRelative(Me![Ôîòîãðàôèÿ])
            fName = Me![Ôîòîãðàôèÿ]
            If (res = True) Then
                fName = path & "\" & fName
            End If
            Me![Êàðòèíêà].Picture = fName
            Me![Êàðòèíêà].Visible = True
            Me.PaintPalette = Me![Êàðòèíêà].ObjectPalette
            If (Me![Êàðòèíêà].Picture <> fName) Then
                Me![Êàðòèíêà].Visible = False
                ErrorMsg.Caption = "Ôîòîãðàôèÿ íå íàéäåíà"
                ErrorMsg.Visible = True
            End If
        Else
            Me![Êàðòèíêà].Visible = False
            ErrorMsg.Caption = "Äëÿ äîáàâëåíèÿ ôîòîãðàôèè íàæìèòå êíîïêó ""Äîáàâèòü/èçìåíèòü"""
            ErrorMsg.Visible = True
        End If
    MsgBox "Îáðàáîòêà äàííûõ äëèëàñü " & Format$((timeGetTime() - t) / 1000, "0.000") & " ñåê."
End Sub


Íî ó ìåíÿ íåìíîæêî äðóãàÿ çàäà÷à ñòîèò. Íóæíî ïîëó÷èòü âðåìÿ çàãðóçêè íå êàæäîé îòäåëüíîé çàïèñè, à âñåõ çàïèñåé â ôîðìå ïðè ïîìîùè Recordset, êîòîðûé, êàê ÿ ïîíèìàþ, ïîçâîëÿåò ïåðåìåùàòüñÿ îò çàïèñè ê çàïèñè àâòîìàòè÷åñêè, à íå âðó÷íóþ.

Äåëî â òîì, ÷òî ó ìåíÿ â êàæäîé îòäåëüíîé çàïèñè ôîðìû õðàíÿòñÿ äàííûå î êàêîì-òî ñîòðóäíèêå + åãî ôîòîãðàôèÿ. È òàêèõ çàïèñåé 20 øòóê. Ò.å. ìíå, ãðóáî ãîâîðÿ, íóæíî óçíàòü, ñêîëüêî ïî âðåìåíè áóäåò çàíèìàòü çàãðóçêà âñåõ 20 ôîòîãðàôèé â ôîðìó.

http://www.sql.ru/forum/1134985/izmerit-vremya-vyvoda-dannyh-na-forme-ispolzuya-taymer-i-recordset


 

Äîáàâèòü êîììåíòàðèé:
Òåêñò êîììåíòàðèÿ: ñìàéëèêè

Ïðîâåðêà îðôîãðàôèè: (íàéòè îøèáêè)

Ïðèêðåïèòü êàðòèíêó:

 Ïåðåâîäèòü URL â ññûëêó
 Ïîäïèñàòüñÿ íà êîììåíòàðèè
 Ïîäïèñàòü êàðòèíêó