Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

50x speed boost on db4o LINQ queries

DZone's Guide to

50x speed boost on db4o LINQ queries

· Database Zone
Free Resource

Read why times series is the fastest growing database category.

(Via emphess.NET)

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:

Db4obects.Db4o.Instrumentation.dll
Db4objects.Db4o.NativeQueries.dll
Mono.Cecil.dll
Cecil.FlowAnalysis.dll

(see http://developer.db4o.com/Documentation/Reference/db4o-7.12/net35/reference/html/reference/tuning/native_query_optimization.html)

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…

http://www.emphess.net/2010/02/11/db4o-performance-pitfalls/

Learn how to get 20x more performance than Elastic by moving to a Time Series database.

Topics:

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}