Very slow with verion 5.00

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cosxp
Posts: 11
Joined: Sun 21 Jan 2007 16:24

Very slow with verion 5.00

Post by cosxp » Wed 10 Nov 2010 18:32

I just noticed since sdac ver 5.x,
query operation become very very slow where table has 100+ fields....

I just verified with dummy table with 200 fields and
running select * from dummytable (empty) takes 10+ seconds
to fetch empty table while previous version takes less than .1 sec.

I'm both unidac & sdac user and unidac doesn't have this behavior.

To run test, just create dummy table as
create table dummytable (
a1 varchar(10),
a2 varchar(10),
..
..
..
a100 varchar(10)
)

more fields become more slow to open query..
Some of my table has 300+ fields and fetching single record
takes 20-30 seconds now.




cosxp
Posts: 11
Joined: Sun 21 Jan 2007 16:24

Post by cosxp » Wed 10 Nov 2010 18:45

To give you more clue,

default value flag was on when it was slow
and turning this one off make it a lot faster..
I just wonder it worked fine with this option on before ver 5.

AndreyZ

Post by AndreyZ » Thu 11 Nov 2010 10:29

Hello,

Only SDAC 5.00.0.1 has this problem. To solve the problem please upgrade SDAC to version 5.00.0.2.

Post Reply