At 10:45 AM 4/17/2004, Sudheer Palaparambil wrote:

> I am using some tables (like sybase's temporary
>table) for report generation purpose. I usually
>delete all records from the table on calling
>the SP and fill the table again with the data and
>return the result set.
>
> My question is which one is best suited for FB ?
>To create and drop the table each time or delete
>the record each time ?

The mechanism best suited to firebird is to construct a stored procedure
that generates the input records for the report without storing them back
on disk. Dropping the table is more efficient than deleting all the
records, though you might, in time, run into the 32K limit on internal
table ids.

Regards,


Ann