On Wed, Apr 26, 2006 at 06:55:21PM +0200, Davide Alberani wrote:
> [first try]
> statementList = []
> for everySetOfData:
> insertObj = sqlbuilder.Insert(Table.sqlmeta.table, values={...})
> statementList.append(connection.sqlrepr(insertObj))
> while statementList:
> connection.query(statementList.pop())
>
> Problem: executing one query for every single set of data is really
> slow.
But Postgres doesn't support inserting many rows from a single SELECT
(at least I don't know a way), so the best you can do is
for everySetOfData:
insertObj = sqlbuilder.Insert(Table.sqlmeta.table, values={...})
connection.query(connection.sqlrepr(insertObj))
Oleg.
--
Oleg Broytmann http://phd.pp.ru/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
