I'm using TopLink as my ORM and MySQL as the DB.
I traded my auto-increment primary keys for GUIDs for one of my tables (alright, not quite: I'm actually using a random 64 bit integer, but that's good enough for my needs).
Anyway, now queries, which don't even use the key, are taking much longer.
What can I do?
If your table is indexed by the fields your are querying by. content of the key shouldn't have any noticeable performance impact. They maybe something else there .