Very slow with verion 5.00
Posted: 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.
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.