Subject | Re: [Firebird-Architect] RFC: Improvements to External Tables |
---|---|
Author | Vlad Khorsun |
Post date | 2008-10-12T18:44:47Z |
>>> Alex Peshkov wrote:Its performance killer, as for me.
>>>
>>>> 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.
>>> Another one would be through remote providers. It could be read-write.When (if) we implement ODBC data source provider it will be able to
>>>
>>
>> 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.
do all ODBC driver can do with any ODBC data source ;) But, again,
for external tables it will kill performance.
Regarsd,
Vlad