inssimple

来自「postgresql8.3.4源码,开源数据库」· 代码 · 共 31 行

# $PostgreSQL: pgsql/src/test/performance/sqls/inssimple,v 1.2 2006/03/11 04:38:41 momjian Exp $
#
# Transactions are unsupported by MySQL - so for insertion of
# 8192 rows, 1 INSERT per Xaction, we returned "Transactions unsupported"
#
if ( $TestDBMS =~ /^mysql/ && $XACTBLOCK eq '' )
{
	print STDERR " No_Xact\n";
	return;
}

`> .sqlf`;	# clean file

#
# PgSQL specific: if all queries from inssimple.data must be executed in
# single xaction ($XACTBLOCK ne '') then add BEGIN/END arround queries
#
`echo "BEGIN;" >> .sqlf` if ( $TestDBMS =~ /^pgsql/ && $XACTBLOCK ne '' );


`cat sqls/inssimple.data >> .sqlf`;


# PgSQL (see above)
`echo "END;" >> .sqlf` if ( $TestDBMS =~ /^pgsql/ && $XACTBLOCK ne '' );

# Ok - run queries
`time $FrontEnd < .sqlf`;