Hi all. I want to improve speed of my database. i always used dataenvironment to access to my datareport. but it so slow. i wonder which one are better, used dataenvironment or don used it? thank for your help.

____________________________
Please help out.

Hi,
I don't really know about DRs, but would suggest that if oyur report is too slow, it may be your queries.
Are you basing your report on queries/Stored Procs or dynamic SQL ( ie. constructing our query in VB rather than the DBMS)? DSQL is recognised as s-l-o-w.
K


____________________________
Build it better, faster, quicker, easier.. then fix it (non-offical MS mission statement)