da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: WaitCursor shows when I navigate DBGrid

Forum List » AnyDAC » v 1.x General English

Lookze
User

Fresh Boarder

Posts: 4

Karma: 0

WaitCursor shows when I navigate DBGrid

Posted: 2008/02/08 00:46

Hi

I have a small application in Delphi with MySQL. On DataModule I have: TADConnection, TADPhysMySQLDriverLink, TADGUIxWaitCursor... On my form I have: TADQuery, TDataSource, SMDBGrid.

Everytime when I scroll DBGrid or go to next (prior) record or click any record in DBGrid there pop up a WaitCursor...... It's very nervy and weird..... Because all data is loaded in DBGrid and there shouldn't be any question to database???? It slowing application and using dbgrid. Database is very small: 12 columns and about 100 rows.... It's not my first application with AnyDac and this is first time when I have this kind of problem... Any suggestion???

Post edited by: Lookze, at: 2008/02/08 00:49

Post edited by: Lookze, at: 2008/02/08 01:05

Diman

Admin

Posts: 1460

Karma: 18

Re:WaitCursor shows when I navigate DBGrid

Posted: 2008/02/08 01:12

Set in the code ADManager.SilentMode to True.

Lookze
User

Fresh Boarder

Posts: 4

Karma: 0

Re:WaitCursor shows when I navigate DBGrid

Posted: 2008/02/08 01:37

Thank's for reply.... Yes, there is no WaitCursor but still scrolling is very slow (in my mind). About 100 rows I'm scrolling by my mouse about 20 seconds... Is it normal????

Post edited by: Lookze, at: 2008/02/08 01:37

Diman

Admin

Posts: 1460

Karma: 18

Re:WaitCursor shows when I navigate DBGrid

Posted: 2008/02/08 01:47

That is VERY not normal. And that is not AnyDAC issue, you can check that your self using simple code with loop.

1) Do you have any event handlers ?
2) I does not know SMDBGrid, may be it have some options to speed up ?
3) Try to use ADMonitor to see what is the exachange with DBMS.

Lookze
User

Fresh Boarder

Posts: 4

Karma: 0

Re:WaitCursor shows when I navigate DBGrid

Posted: 2008/02/08 02:33

OK I'll try to fix it. But problem isn't with SMDBGrid because I've tried with standard DBGrid and was the same...

I have error when I'm compiling ADMonitor.dpr

"File not found: ' daADMoniIndyBase.dcu' ". Problem is with section USES. With declaration "daADMoniIndyServer". I have RAD Studio 2007 and Indy is installed correctly. In my system there is no file named daADMoniIndyBase.dcu ..... I'll try search my code and fix it on foot

Thank's for help!

Post edited by: Lookze, at: 2008/02/08 02:37

I've resolved above error but still can't compile ADMonitor.dpr.... This time shows: Undeclared identifier 'ReadStream' or 'WriteStream' from file daADMoniIndyBase.pas ..... It seems there is no function like 'ReadStream' or 'WriteStream' in FConnection (TIdTCPConnection)

ech

P.S. In Delphi 2005 the same problem....

Post edited by: Lookze, at: 2008/02/08 02:54

Post edited by: Lookze, at: 2008/02/08 03:12

Forum List » AnyDAC » v 1.x General English