R – Now that I’ve converted the primary keys to GUIDs, how to fix the performance


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?

Best Solution

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 .

Related Question