Yup

Thats our plan as well. However my main issue is the performance hit I
get with IBO as it rebuilds the schema every time I add a table.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com

Wild Software Ltd



jack_engleman wrote:

> I create temporary tables in one routine in my program. I create a
> table named t_quick1 first and then my second table for another user
> will be t_quick2. These will get deleted at the end of a report where
> they are created, but I do find that is not always successful. In a
> routine that I run early mourning that eventually does a backup and
> rebuild of the database, I have a SQL command that will delete all of
> the t_quickxx files that are in the database.
>
> This works well for me.
>
> Best Regards
>
> Jack
>
>
>
>
>
>
>
>
> --- In IBObjects@yahoogroups.com, Robert martin <rob@...> wrote:
>
>> Hi
>>
>> We have a screen in our app that creates tables (DDL) to use on a
>> temporary basis. As FB doesn't yet support temp tables we are handling
>> the removal of said tables. However we don't do it well. This
>>
> leads to
>
>> us having a large number of unused tables in our DB at times (we do
>> eventually remove them). However this is not the main issue, it just
>> compounds it.
>>
>> IBO collects a schema of the db and whenever DDL changes take place the
>> schema gets completely regenerated. This is a real problem for us
>>
> as it
>
>> adds a large amount of delay after creating a new temp table. I
>>
> believe
>
>> this is an issue regardless of whether or not the schema is cached (we
>> don't cache). The large number of tables makes this process quite slow
>> (seconds ?)
>>
>> In the help it says I might be able to use executeImmediate to do the
>> ddl without forcing a rebuild of the schema. However my guess is that
>> if I do this than IBO won't 'see' the newly created temp table (that I
>> need to use).
>>
>> Does anyone have a suggestion as to how to get around this?
>>
>> --
>> Rob Martin
>> Software Engineer
>>
>> phone +64 03 377 0495
>> fax +64 03 377 0496
>> web www.chreos.com
>>
>> Wild Software Ltd
>>
>>
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>