uuid primary key performance

Classic Servoy
1

hi! is there a performance hit using servoy uuid generator?

2

none other than the space used is slightly larger (if stored as media it is only 16 bytes).

Rob

3

rgansevles:
none other than the space used is slightly larger (if stored as media it is only 16 bytes).

Rob

Thanks Rob!

We are going to the UUID.

I am getting an exception in the databaseManager.getDataSetByQuery(…)

"Error during evaluation:Wrapped java.lang.RuntimeException: com.servoy.j2db.dataprocessing.DataException: Can't infer the SQL type to use for an instance of com.servoy.j2db.util.UUID. Use setObject() with an explicit Types value to specify the type to use."

e.g.

var sql = "SELECT iduser FROM system_user WHERE iduser=?";
var dataSet = databaseManager.getDataSetByQuery(AUTH_SERVER, sql, [userID], -1);

where userID is a UUID object. So I changed userID to userID.toString()

We have sql queries all over the place. Is there a easier solution? Can servoy map it internally? I already changed sequence type to uuid generator and checked UUID flag.

4

Rogel,

Servoy does map the uuid to a string or bytes for internal queries.
But we don’t parse custom queries so we do not know which column is used in your query.

Rob

5

rgansevles:
Rogel,

Servoy does map the uuid to a string or bytes for internal queries.
But we don’t parse custom queries so we do not know which column is used in your query.

Rob

I see.

Thanks Rob.