Hi Jason (and others :) )

Just tried the executeimmediate solution on a company with about 1300
tables (dummy test data) and the performance improvement was amazing.
It went from about 3 secs to create and connect to a new table to near
instantaneous.

Thanks for you help :)

Rob Martin
Software Engineer

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

Wild Software Ltd



Robert martin wrote:

> Great
>
> Thanks for the Jason. I will put some effort into the code
> modifications required to make these changes. Hopefully all will work
> as desired :)
>
> Thanks for your help.
>
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> Jason Wharton wrote:
>
>>> The docs say that using ExecuteImmediate (From memory) will allow DDL
>>> without triggering a Schema Refresh.
>>>
>>>
>> This is likely true being that there is a separate method ExecuteDDL().
>>
>>
>>
>>> However if I don't refresh the Schema will I be able to see /
>>> use the table.
>>>
>>>
>> It will be available on the server. You may not get some of the things like
>> KeyLinks auto define and other things the schema is used for but you
>> certainly will be able to process any valid SQL that involves use of the
>> table.
>>
>> Jason Wharton
>>
>>
>>
>> ___________________________________________________________________________
>> 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
>>
>>
>>
>>
>>
>>
>>
>
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
>