[Hibernate-issues] [Hibernate-JIRA] Created: (HB-164) Temporary tables

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-164


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-164
    Summary: Temporary tables
       Type: New Feature

     Status: Unassigned
   Priority: Minor

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.1

   Assignee: 
   Reporter: Christian Bauer

    Created: Tue, 8 Jul 2003 3:44 PM
    Updated: Tue, 8 Jul 2003 3:44 PM

Description:
Many dbms provide the ability to create and manage temporary tables that have some level of
optimization, like being kept in memory. I know this is not related to or-mapping, but I see
Hibernate as something more than just or-mapping: it's a tool that raises the ability to
write database independent applications in a more transparent way.
 What do I need temp tables for? Consider a complex query that provides
 a result that's needed in other queries but for performance reasons you don't want to run
this query as a subquery again and again. On the other side, keeping the result in memory is
not efficient as well, think about  something like select ... from ... where id in (...)
where the content of the in clause is the result of the above query: it's definitely easy to
go over the maximum statement length, while this query can be more efficiently expressed
thru a subquery or a join with the temp table.
 
 For the moment I've created a persistent table to put the query result in, but this way you
need to know how many temp tables you need at design time or add a selection column... not
as handy as a temporary table that can be created at run time and has special handling by
the database.


---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira