C
Cor
Hi Charlie,
I cannot resist to answer you because since the time of VB4 a lot has
changes. By instance Internet.
One of the things is that Internet does (did) not allow hugh dataset. So you
have to scale them down.
If you don't do that you have maybe a high performance on your SQL server,
but the user is waiting for his data.
You can see this from which part of the subscribers from this thread come by
the answers (only in house or also Internet).
But I don't say it is not recommended to use there where posible SP, but I
also say that there where it will led to thousands of one time used SP's
it is maybe be better to take another approach.
Just my 2 cents about your new addition to this.
Cor
I cannot resist to answer you because since the time of VB4 a lot has
changes. By instance Internet.
They also improve performance considerably. But the reason I like them the most is that
they generally reduce the amount of code I write (and consequently,
the number of mistakes I make.
One of the things is that Internet does (did) not allow hugh dataset. So you
have to scale them down.
If you don't do that you have maybe a high performance on your SQL server,
but the user is waiting for his data.
You can see this from which part of the subscribers from this thread come by
the answers (only in house or also Internet).
But I don't say it is not recommended to use there where posible SP, but I
also say that there where it will led to thousands of one time used SP's
it is maybe be better to take another approach.
Just my 2 cents about your new addition to this.
Cor