Cache does not work

[thomas.kilian]

I made some performance measurements. According to that, the so-called cache inside EA (Repository.EnableCache) does not work. If turned on it accounts (very best case) for 5% speed improvement. I use automation a lot for querying the DB to make all kinds of exports/reports. Here I strongly count on a non-changing database - and a working cache. EA actually passes everything to the SQL server. If you have a big one sitting behind you it might cache for you, but I work locally on my machine. Now I have wrapped all Repository calls with a cache and it boosts with a factor of 10 (which is 90% instead of 5%)! So what is that EA cache worth at all?

[«Midnight»]

I'm not quite getting what you mean by "wrapped all Repository calls with a cache..."

[thomas.kilian]

I use a proxy class to catch all Repository methods (esp. the getbyid and guid). I can then use my own cache mechanism instead of the not existing EA cache.

[«Midnight»]

That's what I was afraid of. I've been hoping to avoid the overhead, but I suspect that my future leads that way.

Of course that opens up some other avenues, but we can discuss that elsewhere.