Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
5 Queries with 5 diffrenet database
- Thread starter fhurmuzlu
- Start date
What type of database? Are they all the same or are they are they different?
The best way is probably going to be to get the database to do the work for you by setting up links between one database and all of the rest then either use a stored proc in the database or write a command in Crystal that will join all the data together into a single dataset.
If you pull tables or run commands from different connections into Crystal and join them, Crystal will pull ALL of the data into memory and do the joins, filtering, etc. in memory. This is very slow and memory/disk swap intensive.
If you use subreports, you can't combine the data together into a single dataset if that's what you need.
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
The best way is probably going to be to get the database to do the work for you by setting up links between one database and all of the rest then either use a stored proc in the database or write a command in Crystal that will join all the data together into a single dataset.
If you pull tables or run commands from different connections into Crystal and join them, Crystal will pull ALL of the data into memory and do the joins, filtering, etc. in memory. This is very slow and memory/disk swap intensive.
If you use subreports, you can't combine the data together into a single dataset if that's what you need.
-Dell
A computer only does what you actually told it to do - not what you thought you told it to do.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question