I would've thought temporary tables were not thought for speed but I may be
wrong...

On Aug 6, 2013 8:07 PM, "tom.rhodesw" <tom.rhodesw@...> wrote:

> I am trying to evaluate what are the best options for performing some
> calculations and data queries using Firebird tables.
>
> At present I can see two options:
> - use usual tables with dedicated field for storing some session id
> - use global temporary tables
>
> The question is - do global temporary tables have performance advantages
> over usual tables? And whether global temporary tables were designed with
> optimization goal in mind at all? Maybe they have different goals?
>
> Thanks,
> Tomr
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>


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