Subject Re: [Firebird-Architect] Bulk loader.
Author Vlad Khorsun
>>> Are we talking about deferred constraint evaluation by a chance? :)
>>
>> More or less - yes ;) But this is not "true" deferred constraint - in my case its
>> deferred until end of statement, not end of transaction. It may be easyer to
>> implement i think
>
> Ok, you've convinced me here. :)

Good ;) Hope i not mistaken there.

> Now another question: where do we put the files to load? On the file
> system accessible from the server? Should we support remote bulk load?

I don't like artificial limitations. Why should we limit users offering bulk load
from files only ? I prefer to implement generic bulk load API, say prepare statement
for bulk operation, pass into it large (or even huge ;) set of parameters, may be few
times, routine to finish load process and check results. Next we may implement at
higher level bulk loading from file, stream, etc.

Regards,
Vlad