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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-01 : 07:41:07
|
| Hung Cao writes "Hello, I have two questions and would like someone help me with. Please allow my to introduct myself and our business. We're currently testing for the next conversion. We're thinking using SQL server or DB2 for database and our front end would be visual basic, java, etc...1> On SQL server i was impress about the use of store procedure but on the view i'm not impress that much. Here is my problem, I have a form writen in visual basic which run a view of builder which i have create on the SQL server via ADO control. On the form i have another datalist box which i want to list all the security code for the selection builder which i would like run from a view on the SQL server also. But i just find out i can not pass the criteria from one view to another view. Is there other way you can help me with. 2> On the performance, everytime i open my form in my project written in visual basic. It's taking about 3 or 4 min to load the form. Even try to run it. When every load up then the store procedure get call on the fly. Is there the way to make a form load up quicker. Is it not good for have to wait 5 min for the system to start.Please advice." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-01 : 16:11:22
|
| Usually it is better to use stored procedures whenever a client application makes a request of the SQL Server, either for data retrieval or to perform actions (like UPDATE, INSERT or DELETE). If you need to have some kind of dynamic update happen on the client end, small, well-tuned stored procedures can provide excellent performance, especially when passing information as a parameter.As far as the load time, that depends on how much data the stored procedure is returning to the client, and the network connection speed. Without more detail on EXACTLY what your form is loading, or what data needs to update dynamically on your drop down lists, it will be hard for us to help out. If you could post your table structures, view structures, stored procedure code and even VB code it would help a great deal. |
 |
|
|
|
|
|
|
|
SQL Server