Re: [Firebird-test] [FB-Tracker] Commented: (CORE-1978) INSERT with multi-values

[Gustavo T. <gus...@gm...>]

Good night,

Bulk_insert by ISQL?, I use external table for masive load, is very
effective but need more code by to prepare the files and SP's for to process
the data, in other words I need a simple way for insert multiple values (500
or less rows).

I will like to hear your opinion/solutions.


Ing. Gustavo Torres

2010/8/3 Dimitry Sibiryakov (JIRA) <tr...@fi...>

>
>    [
> http://tracker.firebirdsql.org/browse/CORE-1978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=21472#action_21472]
>
> Dimitry Sibiryakov commented on CORE-1978:
> ------------------------------------------
>
> In ISQL it is already implemented as bulk_insert. In DSQL it is less
> effective than array DML. What's the point?
>
> > INSERT with multi-values
> > ------------------------
> >
> >                 Key: CORE-1978
> >                 URL: http://tracker.firebirdsql.org/browse/CORE-1978
> >             Project: Firebird Core
> >          Issue Type: Improvement
> >          Components: Engine
> >         Environment: Software platform
> >            Reporter: Gustavo Torres
> >            Priority: Minor
> >
> > I suggeste include Insert multi-values
> > INSERT INTO Table (a, b, c)
> >  values(1, 2, 3),
> > (4, 5, 6)
> > for improvement performance insert
>
> --
> This message is automatically generated by JIRA.
> -
> If you think it was sent incorrectly contact one of the administrators:
> http://tracker.firebirdsql.org/secure/Administrators.jspa
> -
> For more information on JIRA, see: http://www.atlassian.com/software/jira
>
>
>