Re: 100% CPU usage to do nothing.



Check also that you do not have handlers for AfterScroll/BeforeScroll events, and no details dataset(s).

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Donald S. Bossen" <sbossen@xxxxxxxxxxxxxxx> сообщил/сообщила в новостях следующее: news:4767f2a1@xxxxxxxxxxxxxxxxxxxxxxxxx
Using Delphi6 and ADOData Set and connection componetes.
In this application I am selecting a large amount of data from a Microsoft SQL2005 and noted it running slow the CPU was at 100% and the process was slowing with time. So I commented all out as to have this
TblSql.First
while not TblSql.Eof do
begin
TblSql.next;
end;
and it takes the same length of time with 100% usage. Any Ideas on what is wrong and how to fix.
Thanks
Donald S. Bossen
J&B Importers Inc.


.



Relevant Pages

  • Re: Reading the definition of a view
    ... OpenSchema with siViews, field is VIEW_DEFINITION + siProcedures, field is ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: invalid class typecast
    ... >>Vassiliev V. V. ... >>http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... >>MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: adAffectCurrent not working
    ... Regards, ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... MS Jet and Interbase ...
    (borland.public.delphi.database.ado)
  • Re: D7-access key problem
    ... Do you have primary keys on detail table (or on all tables affected by ... Vassiliev V. V. ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ...
    (borland.public.delphi.database.ado)
  • event and its associated handler for automating predefined actions
    ... I have to adapt an sql script to create a MS SQL Server 2000 data ... possibility to define events and associate them with handlers which ... CREATE EVENT DbStartUp TYPE DatabaseStart ... How can I implement this behaviour for a MS SQL Server 2000 date base? ...
    (microsoft.public.sqlserver.server)