2011/3/29 John Robson <[email protected]>
> On 03/29/2011 12:09 PM, Jack wrote:
> > Is there any reason this needs to be done within your Wt application?
> > Especially if this is for initial population of the database, there is
> > probably a PostgreSQL utility to do a bulk load, which would likely be
> > much more efficient.
>
> Im developing a Web Application to receive files (upload), handle the
> contents of each row (int, float, double, datetime, etc ...) and
> populate PostgreSQL.
>
Postgres has a COPY[1] command for effective import/export a large amount
of data. But I am dubious that Wt::Dbo has a support for it (I mean
transmitting
between client and server via connection). So, you should use libpq directly
to
do it. As a workaround you need to transmit a processed version of uploaded
to
the http server file to the database server and perform COPY which will read
this file directly by the database server, not by client (Wt) application.
Or you may perform a trivial INSERT command for each processed row. In this
you may want to do it inside a one transaction.
> On 03/29/2011 12:12 PM, Dmitriy Igrishin wrote:
> > Do you need to load it once (initially) or you need you load
> > it dynamically from the application at runtime ?
>
> I need to insert many files all the time.
>
>
>
> ------------------------------------------------------------------------------
> Enable your software for Intel(R) Active Management Technology to meet the
> growing manageability and security demands of your customers. Businesses
> are taking advantage of Intel(R) vPro (TM) technology - will your software
> be a part of the solution? Download the Intel(R) Manageability Checker
> today! http://p.sf.net/sfu/intel-dev2devmar
> _______________________________________________
> witty-interest mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/witty-interest
>
--
// Dmitriy.
------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today! http://p.sf.net/sfu/intel-dev2devmar
_______________________________________________
witty-interest mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/witty-interest
