Most efficient sql execution?

Results 1 to 3 of 3

Thread: Most efficient sql execution?

  1. #1
    Kris D. Bernardic Guest

    Default Most efficient sql execution?

    Does anyone know the most efficient means of executing SQL statements and stored procs in ASP? I was looking at and they seem to say that not using the recordset and command object is the best, but don&#039;t really offer any benchmarks or performance tests. The company I work for now uses commands<BR>and recordsets, and they put a heavy emphasis on good performance. Are there any sites out there that offer performance tests to backup the most efficient way to execute sql statements?<BR><BR>Thanks,<BR>Kris<BR>

  2. #2
    Join Date
    Dec 1969

    Default No Choice for SP

    for SPs u must use CommandObject.SQL queries again depends on the complexity, better to use through SPs if complexed,, since they are pre compiled.

  3. #3
    Join Date
    Dec 1969

    Default RE: Most efficient sql execution?

    you could just use a sql command to run your stored procedure.<BR><BR>dim conn<BR>set conn = server.createobject("adodb.connection")<BR>conn.op en "stuff"<BR>conn.execute("exec sp_blah")

Posting Permissions

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