Forum OpenACS Q&A: Response to Multiple row in one insert for PostgreSQL

Collapse
Posted by Kenny Chan on
Hi again,

Btw, if I do sth like:

set sql_insert "insert into table (col_name) values (1);insert into table (col_name) values (2);insert into table (col_name) values (3); insert into table (col_name) values (4)"

ns_db dml $db $sql_insert

is this gonna have good performace instead of dml 4 times? It looks like this is a single db connect to me...

Thanks again.