Results 1 to 2 of 2

Thread: VB6/SQL and Stored procedures - Worth?

  1. Apr 4th, 2001, 08:19 AM #1
    Michel Jr
    Michel Jr is offline

    Thread Starter
    Addicted Member Michel Jr's Avatar
    Join Date
    Jan 2000
    Location
    Brazil
    Posts
    175

    Question

    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.
    Good Activex controls at my HP:
    http://www.geocities.com/michel_junior_hp/index.html
    Reply With Quote Reply With Quote
  2. Apr 4th, 2001, 08:53 AM #2
    MikeHost
    MikeHost is offline
    Addicted Member MikeHost's Avatar
    Join Date
    Nov 2000
    Location
    Missouri
    Posts
    175
    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.
    <<<<>>>>
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width