Hi Giovani

Depend, many workstations use your procedure and so the procedure will be called many times or no? Maybe an auxiliary table or view is a good idea. If you build a view that is changed few times can by more quick that many copies of a procedure executing. You must to study your app to know what is better...

Roberto Novakosky

----- Original Message -----
From: giovanibettiol
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 15, 2005 2:23 PM
Subject: [firebird-support] Procedure or View?



Hello!

I just want to know if there's any difference in performance, etc.
between creating a procedure which returns data and then using a
select statement to retrieve the data or doing the same with a view?
Is it the same?

Any tips accepted!

Thanks in advance

Giovani




Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]