da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Why does activating some tables take so long?

Forum List » AnyDAC » v 1.x General English

gymwalker
User

Senior Boarder

Posts: 23

Karma: 0

Why does activating some tables take so long?

Posted: 2005/07/16 01:15

Why does activating some tables take so long? I have an ItemMast Table (MSSQL) that has about 37,000 rows and takes just 2 or 3 seconds to activate (ItemMast.Active := true) and then I have a couple others with several million rows that take 45 to over a minute to activate?

Is there anything I can do to speed up this time?

Diman

Admin

Posts: 1509

Karma: 20

RE: Why does activating some tables take so long?

Posted: 2005/07/16 14:45

Hi !

If TADQuery.FetchOptions.Mode is fmAll then set it to fmOnDemand. Is that your case ?

Regards,
Dmitry

gymwalker
User

Senior Boarder

Posts: 23

Karma: 0

RE: Why does activating some tables take so long?

Posted: 2005/07/19 11:35

It is the TADTable that I'm activating...do I even need to do that? I don't think I even need a table if I'm using a Query do I? Let me skip the TADTable.Active := true step...and just use the TADQuery.Active or Refresh methods and see what happens...as you can tell, I'm kind of new at this remote DB stuff and may be doing some things I shouldn't...thanks for your patience and help!

Jim

gymwalker
User

Senior Boarder

Posts: 23

Karma: 0

RE: Why does activating some tables take so long?

Posted: 2005/07/19 12:37

It does run faster when I don't 'Activate' the Tables...and just Activate or Refresh the Queries.

All of the Tables and Queries were set to OnDemand...so I'm not sure why it was taking so long to Activate? Is there any other settings I should be aware of?

Thanks again!!!
Jim

Forum List » AnyDAC » v 1.x General English