Subject | Re: External Table Performance |
---|---|
Author | kevlingo |
Post date | 2003-05-09T19:23:20Z |
Thanks, Sean!
I figured it was a bad idea, but I didn't want to discount it altogether before hearing from someone who knows fer sher...=)
Thanks again.
Kevin Lingofelter
I figured it was a bad idea, but I didn't want to discount it altogether before hearing from someone who knows fer sher...=)
Thanks again.
Kevin Lingofelter
--- In ib-support@yahoogroups.com, "Leyne, Sean" <sleyne@a...> wrote:
> > I am thinking of using them for user data in a lookup database.
>
> Don't do it!
>
> First, the tables, once openned, are locked by the engine for writes.
> The engine is allowed to write to external files.
>
> Second, the external data may be cached by the engine, so any updates
> might not get noticed.
>
> Third, it's just a bad idea.
>
>
> Sean