Dismiss Notice

REGISTRATION IS AFTER ADMIN ACTIVATION

DONATIONS WITH PAYPAL CLICK TO BUTTON

1 MONTH VIP - 5$; 3 MONTHS VIP - 10$; 6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$

DONATIONS WITH Bitcoin Address:3NRs3CK3fhXifrNYxHEZKpETDd9vNLMsMD

Dismiss Notice
The registration is approved by the Administrator. It takes about 1 day to approve your registration
Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

Fast Looping

Discussion in 'Delphi Help&Requests' started by sitinurazizah, Jun 20, 2014.

  1. sitinurazizah
    Offline

    sitinurazizah Guest

    hi..

    i have problem to select 124000 record of mysql database to list view quickly..i have wrote this code to load it :

    ADOQuery2.Active:=false;
    ADOQuery2.SQL.Text:='select judul,artis from lagu order by popular limit 0,124000 ';
    ADOQuery2.Active:=true;

    ADOQuery2.First;
    while NOT(ADOQuery2.Eof) do
    begin

       Itm := ListView1.Items.Add;
       Itm.Caption := ADOQuery2judul.Value;
       Itm.SubItems.Add(ADOQuery2artis.Value);
       Application.ProcessMessages;
       Sleep(1);
       ADOQuery2.Next;
    end;

    need about 4 minute until form show..because i put the code in formcreate event.

    is there a faster way to do it?


    thanks before

    Best regard,

    pram
     
  2. N0body
    Online

    N0bodyN0body is a Verified Member DelphiFan Administrator Staff Member DF Staff

    RE:

    maybe you must use thread or multithread for this count 124 000 isnt small value
     
  3. N0body
    Online

    N0bodyN0body is a Verified Member DelphiFan Administrator Staff Member DF Staff

    RE:

    One example for you

    Code:
    The main code goes in the thread's Execute method:
    Code:
     procedure TCalcThread.Execute;
     var
       Qry : TADOQuery;
       k : integer;
     begin
       inherited;
     
       CoInitialize(nil) ; //CoInitialize was not called
     
       Qry := TADOQuery.Create(nil) ;
       try
     // MUST USE OWN CONNECTION
     // Qry.Connection := Form1.ADOConnection1;
         Qry.ConnectionString := ConnStr;
         Qry.CursorLocation := clUseServer;
         Qry.LockType := ltReadOnly;
         Qry.CursorType := ctOpenForwardOnly;
         Qry.SQL.Text := SQLString;
     
         Qry.Open;
         while NOT Qry.Eof and NOT Terminated do
         begin
           ListBox.Items.Insert(0, Format('%s - %d', [Qry.Fields[0].asString,Qry.Fields[1].AsInteger])) ;
     
           //Canvas Does NOT Allow Drawing if not called through Synchronize
           Synchronize(RefreshCount) ;
     
           Qry.Next;
         end;
       finally
         Qry.Free;
       end;
     
       CoUninitialize() ;
     end;
     

Share This Page

Laws
Our website, law, laws, copyright and aims to be respectful of individual rights. Our site, as defined in the law of 5651 serves as a provider of space. According to the law, contrary to the law of site management has no obligation to monitor content. Therefore, our site has adopted the principle of fit and remove. Works are subject to copyright laws and is shared in a manner that violated their legal rights, or professional associations, rights holders who, adsdelphi@gmail.com I can reach us at e-mail address. Complaints considered to be infringing on the examination of the content will be removed from our site.
Donate Help To Us and Be VIP
DONATIONS WITH PAYPAL CLICK TO BUTTON
6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$
Social Block