-----Original Message-----
From: Marco Yandun
Sent: Thursday, March 20, 2003 12:14 PM
To: 'Application Development'
Subject: A question about store procedures


Hi all,

I am doing an application in .NET.

Could anyone tell me if there is something wrong if I do all of my 
queries via store procedures.  Is there any impact in performance?.  
Does it depend on the DBMS I am using, e.g. Oracle or SQL server 2000?

Thank you in advance,
Marco.

Marco,

<< is something wrong if I do all of my queries via store procedures>>
No, it's fine.  I don't know if I would want this to be a hard and fast rule
for the project though. It may be possible that some would not be and some
would be. For instance, if you are building certain queries at run time you
would not be best to use a stored procedure for that.
<<Is there any impact in performance?>>
Yes. Performance will improve.
<<Does it depend on the DBMS I am using, e.g. Oracle or SQL server 2000?>>
No, not if they are typical queries.

Regards
----- Original Message -----
From: "Marco Yandun" <marco.yandun@o...>
To: "Application Development" <application_development@p...>
Sent: Thursday, March 20, 2003 10:22 AM
Subject: [application_development] A question about store procedures and
.net




-----Original Message-----
From: Marco Yandun
Sent: Thursday, March 20, 2003 12:14 PM
To: 'Application Development'
Subject: A question about store procedures


Hi all,

I am doing an application in .NET.

Could anyone tell me if there is something wrong if I do all of my queries
via store procedures.  Is there any impact in performance?.  Does it depend
on the DBMS I am using, e.g. Oracle or SQL server 2000?

Thank you in advance,
Marco.

Stored procedures will, in many cases,  work faster then the query-in-code
equivalent.
IMHO, using SP is a very good way to separate database logic from the rest
of your application.  You can use the same codepart (sp body) wherever you
need it, and changing it won't affect your application.

I'm not 100% sure stored procedures will have the same syntax for oracle or
sql-server...

> ----------
> From: 	Marco Yandun[SMTP:marco.yandun@o...]
> Reply To: 	Application Development
> Sent: 	jeudi 20 mars 2003 18:22
> To: 	Application Development
> Subject: 	[application_development] A question about store procedures
> and .net
> 
> 
> 
> -----Original Message-----
> From: Marco Yandun 
> Sent: Thursday, March 20, 2003 12:14 PM
> To: 'Application Development'
> Subject: A question about store procedures
> 
> 
> Hi all,
> 
> I am doing an application in .NET. 
> 
> Could anyone tell me if there is something wrong if I do all of my queries
> via store procedures.  Is there any impact in performance?.  Does it
> depend on the DBMS I am using, e.g. Oracle or SQL server 2000?
> 
> Thank you in advance,
> Marco.
> 
> 


=======================================================
Voir texte francais apres texte neerlandais

Deze email, met inbegrip van elk bijgevoegd document, is vertrouwelijk. Indien u niet de geadresseerde bent, is het openbaar maken,
kopieren of gebruik maken ervan verboden. Indien u dit bericht verkeerdelijk hebt ontvangen, gelieve het te vernietigen en de
afzender onmiddellijk te verwittigen. De veiligheid en juistheid van email-berichten kunnen niet gewaarborgd worden, aangezien de
informatie kan onderschept of gesaboteerd worden, verloren gaan of virussen kan bevatten. De afzender wijst bijgevolg elke
aansprakelijkheid af in dergelijke gevallen. Indien een controle zich opdringt, gelieve een papieren kopie te vragen. 


Ce message electronique, y compris tout document joint, est confidentiel. Si vous n'etes pas le destinataire de ce message, toute
divulgation, copie ou utilisation en est interdite. Si vous avez recu ce message par erreur, veuillez le detruire et en informer
immediatement l'expediteur. La securite et l'exactitude des transmissions de messages electroniques ne peuvent etre garanties etant
donne que les informations peuvent etre interceptees, alterees, perdues ou infectees par des virus; l 'expediteur decline des lors
toute responsabilite en pareils cas. Si une verification s'impose, veuillez demander une copie papier. 
=======================================================