When large amount of records is instantiated (like 100000)
Looking for a record by ID (32 bytes of UUID) is much much slower before flushing to the database.
Seems that before flushing the search is simply looking for the matching record without using any indexing.
When accessing the database, it takes few milliseconds.

Hi,

I don't understand what you are saying/asking. When you are saying "looking for a record by id", do you mean doing a fulltext search for the record? Or what do you do? Regarding fulltext search, if your objects are newly created and you are relying on automatic indexing you will have to commit your transaction before you can even search, because per default the indexing will occur at commit time.

Maybe you can clarify what your question is?

--Hardy