CR's Fast DB Access Ways

[vincentg]

Some said, CR is slow. Some said CR is great! Question is what are the ways to make your CR's DB Retrieval fast.

I dont know if I made it right. I got a SQL Database and VS2003. I used the CR VS2003 in my application. What I did is..

1. I create a SP in the SQL Server DB (Complex one..more inner joins/outer join/sometimes CROSS join..with Parameters like Date Range, Type Criterias, etc, etc)
2. I retrieve my SP using the SQLCommand Object, SqlDataAdapter and DataSet
3. I layout already the CR using the Wizard and using my SP with parameters needed.
4. Coding the Form, retrieving the Data using the Step 2. and coz I want my End user to have a flexible options I programmatically allow my user to change the DataSet and uses this coding

oCrystal.SetDatabaseLogon("MyServer", "pass", "user", "dbname")
oCrystal.SetDataSource(MyDataSet.Table(0))

What are still the best way to make your CR DB Retrieval fast??

Any insights, suggestion, comments, etc are appreciated. TY

[shakti5385]

Not say so much but all think depend on the data how much data you are calling in the CR, as the data increase the speed of filling the data in the CR get little slow, but it does not affect you program.
I check the CR in my project by call the 1500 book record at a time but it does not affect so much.
It all depend on you that how much data you are using and where is the database located, means if the database is on the same PC then no reason that the CR will get slow, but if it is on the other PC then LAN/WAN connection may be make it slow.
But I never get this problem till.