Re: [Monetdb-developers] Why the Speed of Mapi Lib is so lower?

On 06-10-2010 21:13:54 +0800, peter qin wrote:

Dear all, Yesterday,I had done a test about the speed of MonetDB.I used the example code make a test.the red part is my adding code.

Mapi is not MySQL's lib, and not targetted at single statement speed. Batch multiple statements in a single call, instead.

for(int i = 0;i<10000;i++) { update(dbh, "INSERT INTO emp VALUES ('John', 23)"); } //why this cast more then serveral minutes .can you help me?