This is just a quick note, but I just gotta share this now.
It’s actually in the manual so this is not exactly a secret, but I managed to overlook it so perhaps I’m not the only one…
In our specific scenario, db4o was about 3 times slower than MSSQL via Linq to SQL in the past days.
Just a few minutes ago, I finally read this:
Native Query optimizer for .NET requires the following libraries to work:
I added these dll’s to my solution and wooosh! Now it’s up to 50 times faster than before! That’s what I needed… Will see how this works with larger data sets…