If you use a separate connection and do your temp table operations in it,
isolated from the other stuff, then perhaps it won't trigger the schema
cache to be refreshed.

Jason

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
> Behalf Of Robert martin
> Sent: Thursday, May 17, 2007 3:52 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] performance issue when adding tables
>
>
> Hi Jason
>
> I don't know if I need the temp tables to show in he cache. I do use
> them so I guess so. I suppose what I am after is a partial
> refresh. i.e.
>
> a) create new table
> b) Add new table details to existing schema
> c) Access table
>
> as opposed to the current situation (I think)
>
> a) create new table
> b) Access (any) table, Entire schema is refreshed
> c: Access table
>
> Hope this helps your understanding of the situation :)
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd