VB6/SQL and Stored procedures - Worth?

Hi,

I'm using VB6 with ADO and SQL 7.
I would like to know if it worth using Stored Procedures to access tables, or it's better to load a RecordSet every time I open my program?

Thanks in advance...

Michel Jr.

Stored procecures are the way to go if you have an SQL that will be executed mulitiple times, or if you have a lot of traffic on your server. Each time you send a SQL to the Server, it has to do a mini compile on it. Stored procedures are pre-compiled. I believe that there is also the option to use caching with stored procedures.