Skip to main content
H
haire
Known Participant
October 13, 2006
Question

Performance using CFC and Stored Procedure!

  • October 13, 2006
  • 1 reply
  • 595 views

hi guys,

i just want some opinion or suggestion on these thing ?

1. is there any different at the web server and database server performance if i'm calling a query using this method :

a. Using stored procedure SP_A to call a query Q_A
b. Using a CFC to call a Stored Procude SP_A that calling query Q_A

which one is better if i'm using two server, 1 Web Server and another a Database Server in a different location.

Thanks for the info


    This topic has been closed for replies.

    1 reply

    D
    Dan_Bracuk
    Inspiring
    October 16, 2006
    The database does not care whether the stored procedure is called from a cfc or a normal .cfm file. If the stored procedure does not do anything besides calling query a, it is an unnecessary complication. If it does, but your app only needs query a, you are being inefficient.

    If the cfc is only being used by one .cfm file, it is an unnecessary complication.
    P
    paross1
    Participating Frequently
    October 16, 2006
    quote:
    If it does, but your app only needs query a, you are being inefficient.

    Dan,
    Your reply is somewhat of a generalization, since I have Oracle apps that have no SQL at all in ColdFusion, and all database functionality is written in PL/SQL stored procedures. It was designed this way for many reasons; security, modularity, division of develpment duties between GUI and backend database developers to name three. So, I would not say that it is necessarily inefficient to have a procedure that does nothing but execute a query if all of your SQL is in stored procedures, especially if you want that same procedure available to other front ends than ColdFusion.

    Just my 2 cents....

    Phil
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices