[MonetDB-users] update query performance
5 Dec
2007
5 Dec
'07
9:46 a.m.
Hello,
I have a question. I have a table with the columns ( id, name (string), num(int) ). In this table I have lets say 100 rows of data. In a Java app. I am updating the different rows individually with the sql command: "UPDATE "tableName" SET "num" = ('99') WHERE "id" = (5);"
The time to run this single query is between 15 to 32 milliseconds, except every once in a while when it can be as much as 110 milliseconds.
Since I want to do this several times each second for all rows this is way to long time. Am I doing something wrong, or am I using Monet in a way that it is not meant to be used or what ? Is there another way to solve this (Updating individual cells/variables in individual rows FAST) ?
Thanks for any input! Regards, Marcus
6009
Age (days ago)
6009
Last active (days ago)
0 comments
1 participants
participants (1)
-
Lange Marcus