Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SimonGough
Starting Member
23 Posts |
 Posted - 2002-01-21 : 09:04:46
|
| Hi, I have a large VB form which uses 2 db's on seperate servers to load data into combo's lists etc. when the form loads. This can sometimes take upto 10 seconds to show itself, even on my small network in the office. Is there any way I can speed this up by caching the bigger SP's or maybe View's would help??Thanks for any suggestions.Simon |
|
|
Nazim
A custom title
1408 Posts |
Posted - 2002-01-21 : 09:50:55
|
| you can use both. additionally can create suitable indexes to speed up the performance.put your VB Code here . Some good suggestions might come up from the team ,if required.--------------------------------------------------------------Dont Tell God how big your Problem is , Tell the Problem how Big your God is |
 |
|
|
|
|
|
Slow access time - any thoughts?