[MonetDB-users] Prepare statements as performance upgrade?
12 Jan
2012
12 Jan
'12
11:58 a.m.
Hi, When I look into the executemany implementation of the Python DBAPI, I see that executemany is implemented as loop over the parameters given the same statement. In the mapi documentation there is written about using mapi_prepare_array() and mapi_execute_array(). Would such thing be beneficial in the general case? In my own program I have the following: while True: received = data_from_network() update_monetdb(received) It seems that the standard DBAPI doesn't expose prepared statements as some sort of transparent usage, so using SQL PREPARE sounds as the most logical way. What is the SQL statement to 'forget' the stored prepared statement? Stefan
4734
Age (days ago)
4734
Last active (days ago)
0 comments
1 participants
participants (1)
-
Stefan de Konink