It is no standard way to for this trick, It depends on RDBMS implementation.
It is possible upload tab separated text file to server and execute native
SQL on postgersql like this:
"COPY mytable FROM filename "
http://www.postgresql.org/idocs/index.php?sql-copy.html
> Hey!
>
> The stuff you mention sounds cool, and I already thought about that, but
to
> my knowledge there's no java api that supports stuff like that. If you
know
> a api that supports such functionality, please tell me, that would be
really
> great!
>
> regards
> chris
> ----- Original Message -----
> From: "Juozas Baliuka" <[EMAIL PROTECTED]>
> To: "Christoph Sturm" <[EMAIL PROTECTED]>; "Gavin King"
> <[EMAIL PROTECTED]>
> Cc: "hibernate list" <[EMAIL PROTECTED]>
> Sent: Monday, November 25, 2002 6:03 PM
> Subject: Re: [Hibernate] Re: slow performance on flush
>
>
> >
> > It is better to use some "native" API like "COPY" for long running
import,
> > some RDBM's support imports without constaint
> > checks, SQL parsing .... , and sometimes "long running import" becomes
> very
> > "short".
> >
> > ----- Original Message -----
> > From: "Christoph Sturm" <[EMAIL PROTECTED]>
> > To: "Gavin King" <[EMAIL PROTECTED]>
> > Cc: "hibernate list" <[EMAIL PROTECTED]>
> > Sent: Monday, November 25, 2002 3:27 PM
> > Subject: [Hibernate] Re: slow performance on flush
> >
> >
> > I have a really long running import, and I want to write the records to
> the
> > db as they come in. Is it save to clear the entries Map after a flush?
Or
> > would you recommend a different approach?
> >
> >
> > ----- Original Message -----
> > From: Gavin King
> > To: Christoph Sturm
> > Cc: hibernate list
> > Sent: Monday, November 25, 2002 2:23 PM
> > Subject: Re: slow performance on flush
> >
> >
> > Yup, all entries are kept in the session cache until you close the
> > session. Why would you use this kind of code?? Just flush() once at the
> end
> > (outside the loop).
> > ----- Original Message -----
> > From: Christoph Sturm
> > To: [EMAIL PROTECTED] ; Gavin King
> > Sent: Tuesday, November 26, 2002 12:18 AM
> > Subject: slow performance on flush
> >
> >
> > Hi all!
> >
> > I'm trying to increase the performance of this pseudocode:
> >
> > for (j=1;j<100;j++)
> > {
> > for (i=1;i<100;i++)
> > {
> > session.save(class)
> > }
> > session.flush();
> > session.connection().commit();
> > }
> >
> >
> > Now my problem is that flush doesnt take a constant time, but every
> > invocation of flush takes more time than the last one, the more I flush
> the
> > slower it gets. To me it looks like hibernate keeps the references to
the
> > flushed objects in the entries map, and doesnt remove them. Is there
> > anything I can do about it?
> >
> > regards
> > chris
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > hibernate-devel mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/hibernate-devel
> >
>
-------------------------------------------------------
This SF.net email is sponsored by: Get the new Palm Tungsten T
handheld. Power & Color in a compact size!
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
