Subject Re: [Firebird-Architect] RFC: Improvements to External Tables
Author Vlad Khorsun
>>> Alex Peshkov wrote:
>>>
>>>> First problem. Currently external engines access is actively developed by
>>>> the project. Looks like very soon we will be able access virtually any
>>>> file format using ODBC. Would not extending of external tables be just a
>>>> duplication of our efforts in that direction?
>>>>
>>> Yes, and in two different ways.
>>>
>>> One would be through selectable Java procedures, using any (or ODBC)
>>> JDBC driver. It will be read-only.

Its performance killer, as for me.

>>> Another one would be through remote providers. It could be read-write.
>>>
>>
>> Adriano, are there future plans to work directly with remote tables? i.e.
>> INSERT or SELECT?
> AFAIK, this is the future for work started with remote exec. statement.
> So I leave this question to Vlad.

When (if) we implement ODBC data source provider it will be able to
do all ODBC driver can do with any ODBC data source ;) But, again,
for external tables it will kill performance.

Regarsd,
Vlad